Select all Sheets Error

[dolphinv4]

Hi,

I tried to select all sheets in a database i have by
having this macro:

Sub Test()

Sheets.Select

End Sub

but there is an error "Runtime Error 1004 -
Method 'select' of object 'Sheets' failed".

However, when I open a new workbook and do this, the
macro works. Why?

Regards,
Val

 

[Ron de Bruin]

Hi Val

You have hidden sheets in that workbook