There are somethings that you can't do in a shared workbook.

One of the things you can't change is the protection of a worksheet.



Duffer wrote:

I have been trying to find something like my problem in the KB, but no luck.
Here goes:
I have a shared workbook in which I have protected a worksheet and a macro
attached to a graphic. I wrote code that will unprotect the worksheet while
the macro is running, then password protect the sheet again as the macro is
closing down.
However, once I share the workbook, I can't run the macro! Is there any way
I can protect a sheet in a shared workbook yet still run a macro on it??
Thanking you in advance

--

Dave Peterson