Thread: Xlveryhidden
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
K1KKKA K1KKKA is offline
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