Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle Between SheetVeryHidden and SheetVisible
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle Between SheetVeryHidden and SheetVisible
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle Between SheetVeryHidden and SheetVisible
Since you have not specified which sheets or such I will have to be very
general. You can use code such as Sheet1.Visible = xlsheetveryhidden which refers dirctly to the sheet object using it's code name or Sheets("MyTabName").Visible = xlSheetVisible Which refers to the sheet by tab name. -- HTH... Jim Thomlinson "DBavirsha" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle Between SheetVeryHidden and SheetVisible
Jim,
I have the following macro that I use to unhide the hidden worksheets in my workbook: Dim wkSht As Worksheet For Each wkSht In ActiveWorkbook.Worksheets With wkSht If .Visible = False Then ..Visible = True End If End With Next wkSht End Sub From your previous recommendation, I have now changed some of the properties of some of the worksheets in my workbook from 'Hidden' to 'VeryHidden'. What I would like to do is create a macro or modify the above macro to change the properties of the 'VeryHidden worksheets in my workbook to 'Visible' worksheets. Thanks for your patience. Dave "Jim Thomlinson" wrote: Since you have not specified which sheets or such I will have to be very general. You can use code such as Sheet1.Visible = xlsheetveryhidden which refers dirctly to the sheet object using it's code name or Sheets("MyTabName").Visible = xlSheetVisible Which refers to the sheet by tab name. -- HTH... Jim Thomlinson "DBavirsha" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toggle Code | Excel Programming | |||
Toggle calculation | Excel Programming | |||
How to toggle | Excel Programming | |||
Toggle Button | Excel Programming | |||
Toggle subtotals... | Excel Programming |