View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim[_36_] Tim[_36_] is offline
external usenet poster
 
Posts: 16
Default Hiding sheets with macro disabled - with a big twist!

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