Worksheets hidden

[Jean-Pierre Hermans]

Hello,

When i put in workbook_open the following code :

For Each ws In Worksheets
ws.Visible = xlSheetHidden
Next

I get an error code: runtime error 1004 unable to set the visible property
of the worksheet class

Does anyone know how to solve that ?

Thnx.

 

[RWN]

Not an expert, but;
I think there must be at least one visible WS in a Workbook.

 

[Tom Ogilvy]

At least one worksheet needs to be visible.

for i = 2 to worksheets.count
worksheets(i).Visible = xlSheetHidden
Next