I should have specified that I run macros on the workbook while I am
modifying it in the unprotected and unshared mode. Once I complete the
changes to the workkbook I protect and share the workbook which, I agree,
disables the macros.

Thanks again, Dave

"Jim Thomlinson" wrote:

Shared workbooks and macros genearlly do not get along. Sharing is a type of
protection that locks out certain functionallity. With the functionallity
locked out the macros can not manipulate those settings. I beleive that sheet
visibility is one of those settings so you are out of luck.
--
HTH...

Jim Thomlinson


"DBavirsha" wrote:

I maintain a workbook that contains several hidden worksheets, some unhidden
worksheets, and this workbook is password protected and shared. I do not
want the users to have the ability to unhide the hidden worksheets in my
workbook.

Since I hide and unhide different worksheets in the workbook every week, I
would like to use a macro to toggle between the €˜SheetVeryHidden property
and the €˜SheetVisible property.

Thanks for the help