View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
TroyW[_2_] TroyW[_2_] is offline
external usenet poster
 
Posts: 94
Default Doing something wrong - xlVeryHidden

Kevin,

A slightly different approach would be to use the CodeName of the sheet in
your statement.

For example if "Graph Data" has a CodeName of "Sheet1" then the statement
would be:
Sheet1.Visible = xlSheetVeryHidden

Troy

"Kevin" wrote in message
...
I'm doing something wrong with a very simple command.
When I step through the Auto_Open macro it seems to
execute fine, but the worksheet is still visible. What's
wrong with the following?

Worksheets("Graph Data").Visible = xlVeryHidden

What have I done stupid with this simple statement?

thanks in advance

kevin