LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Sheets.Add disabled Willem Excel Worksheet Functions 5 May 2nd 09 10:09 AM
Copy many sheets into one twist Andy Excel Discussion (Misc queries) 2 March 6th 09 01:42 AM
Hiding and Showing Sheets using Macro engbe Excel Discussion (Misc queries) 3 May 12th 08 05:14 AM
Function To Add across Multiple Sheets with a Twist Sean Excel Worksheet Functions 11 August 8th 07 10:48 PM
Summing across multiple sheets with a twist hillmic Excel Worksheet Functions 5 June 27th 05 04:56 PM


All times are GMT +1. The time now is 04:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"