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 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
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