Select all sheets - Error 1004

[nagovind]

Dear All,
In my workbook which I was using for many years, ended with this error
Simple code used in another new workbook is working well
Both worksheets are attached for reference
The workbook that shows error has to be rectified as it is my original workbook with other sheets deleted

Kindly do the needful
Regards
Narayan Govind

 

[nagovind]

Reference files

 

[vletm]

nagovind
You cannot select hidden sheet (There are six sheets).
Or
What would be the 2nd sheet? ( not that which can see Sheet2 )

 

[nagovind]

Vletm,
I have already tried but it is not working
In the attached sheet I used the code but not succeeded
I really have no idea over the other sheets
How to find them
Suddenly this error appeared
Please help

 

[vletm]

nagovind
What have You tried?
What is that hidden sheet?
There is password to check VBA, can You take it away?

 

[nagovind]

Sorry
Attached is the file without VBA password
I have tried your code
I haven't created the hidden sheet
Please refer to the attached file

 

[nagovind]

HI
Found the solution
From your TIPS


Thanks a lot

 

[vletm]

nagovind
... as written in #3 reply

 

[nagovind]

Yes it is from your inputs
I was not aware of the hidden sheet it is created by another add-in now I found it because of your inputs
I unhid from the sheet property
Thank you once again