View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DBavirsha DBavirsha is offline
external usenet poster
 
Posts: 10
Default Toggle Between SheetVeryHidden and SheetVisible

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