Home > Forum Home > Analyzing Corporate Financial Data > 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 TopicPost Reply Login

Error 1004 After Protecting Sheet

Rate this:
(3/5 from 1 vote)
Confused
Hi
I am working on project on Excel sheet where I have to validate data entered in the particular column in the sheet.
I have written the code for the same in VB, which works fine.
Now, I have to protect the sheet so that I can stop user from make unnecessary changes.
After protection, it dosn't allow me to execute any code, it generates error code 1004.
How to solve the problem? Or is it any way to make particular row/column Readonly, insted of protecting sheet?
 
 Posted by on
 
Replies - Displaying 1 to 2 of 2Order Replies By: Most recent | Chronological | Highest Rated
Confused
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 on
Happy
Rate this:
(3/5 from 1 vote)
Instead of prtecting the entire sheet, you can protect cells individually.  Select the row(s) or column(s) you want to protect and then choose the protection from the cell formatting menu option.
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

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