0

Hi All,

If i protect a sheet then I am getting this runtime error stating

Run time error '1004'
Application-defined or object-defined error


Its not highlighting where is the error .. can anybody help me please i have deadline by today evening..

thanks

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by palavi
0

Hi All,

I got what was the problem, i made few cells locked so i f i make that sheet protected locked cells cannot be used...which was making macro not workable so i was getting this error.

once i unlocked the cells and then tried to protect the sheet.. i didnt face this run time error.

Thanks,
Palvi


Hope this will be helpful for others.


Hi All,

If i protect a sheet then I am getting this runtime error stating

Run time error '1004'
Application-defined or object-defined error


Its not highlighting where is the error .. can anybody help me please i have deadline by today evening..

thanks

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.