Protect Sheets with Edit Object

[ptmuldoon]

I have a (crappy) script that I wrote in the past that will loop through and protect all worksheets. It does the job, but is not very pretty.

But I just learned that currently that when the sheets are protected, the user can not enter comments into an unprotected cell. Thus, I need to possibly allow/enable Edit objects somehow. Could someone possibly show how to do that?

Also, I may want to rethink and use Userform and let the user pick and choose which worksheets should be protected. but that would probably be a separate topic.

This is my current script.

Please Login or Register  to view this content.

[Greg M]

Hi there,

Try:

Please Login or Register  to view this content.

but be aware that Objects other than Comments will also be unprotected.


Hope this helps - please let me know how you get on.

Regards,

Greg M