Member Avatar for palavi

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
  • 131 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by palavi
Member Avatar for palavi

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.