Home > Forum Home > Analyzing Corporate Financial Data > Error 1004 after protecting sheet > Error 1004 after protecting sheet | Share |
Forum Topic | Login |
Error 1004 After Protecting Sheet | Rate this: (3/5 from 1 vote) |
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 Jimmywick on |
View Full Post |
Find relevant Excel templates and add-ins for Error 1004 after protecting sheet in the Excel Business Solutions Directory |