Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Any help on this problem would be appreciated.
I have a work book with 13 sheets. Prior to distributing the work book to clients I 'very hide' selected sheets so they cannot view the information contained on the sheets. The sheets I 'very hide' depend on what type of client I send the work book to and every client is slightly different.Therefore the hidden sheet selection changes every time I send out the work book. My problem... If the client does not enable macros I want him to see only a warning sheet (saying in order to view this workbook you must select 'enable macros'). However if he does enable macros I want him to see only the sheets I want him to. I know how to do this when macros are enabled and all sheets, except the warning sheet are ment to be visible however how do I still 'very hide' the sheets I want 'very hidden'? Any ideas would be appreciated. Thanks Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Sheets.Add disabled | Excel Worksheet Functions | |||
Copy many sheets into one twist | Excel Discussion (Misc queries) | |||
Hiding and Showing Sheets using Macro | Excel Discussion (Misc queries) | |||
Function To Add across Multiple Sheets with a Twist | Excel Worksheet Functions | |||
Summing across multiple sheets with a twist | Excel Worksheet Functions |