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

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