Home > Forum Home > Analyzing Corporate Financial Data > Error 1004 after protecting sheet > Error 1004 after protecting sheet Share

Error 1004 after protecting sheet

Excel Help for Error 1004 After Protecting Sheet in Analyzing Corporate Financial Data


Forum TopicLogin

Error 1004 After Protecting Sheet

Rate this:
(3/5 from 1 vote)
Confused Then go to the immediate window (Ctrl+G) and take a look at the report written there. It should look like this:


Sheet1 is not protected!

Sheet2 is protected!

In general, try to avoid GoTo in VBA (and in every programming language), unless it is for error-catching. People become mad when they see these.
 Posted by on
 
View Full Post

Find relevant Excel templates and add-ins for Error 1004 after protecting sheet in the