Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default Xlveryhidden

Hi all,


Am at a loss here, upon opening my workbook i want a sheet to be
veryhidden, so as not to appear in the Fromat,sheet,unhide, list of
hidden documents.


was using the following code, but alas am getting the message below
the code


CODE

Sub Workbook_open()
Worksheets("Plan").Activate
Sheets("payroll").Visible = xlveryhidden
End Sub


ERROR MESSAGE

Compile error in hidden module: thisworkbook


HYCH



Steve

 
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



All times are GMT +1. The time now is 12:14 PM.

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"