Hidden Sheet - By Code - Excel Gurus Required

[ihmunro]

Afternoon

I have a file that I did not create. The person that did create the file has left the company, so I am stuck with trying to unhide it.

In the Properties windows under Visible it state 0 - xlsheetHidden. When I try to change it to -1 - xlsheetVisible, I get an error saying it cannot be changed.

Any ideas to help me unlock this would be appreciated.

Happy New Year to everyone.

Iain

 

[Barrie Davidson]

I'd like a shot at too if that's okay!

 

[ihmunro]

Hi Barrie

It is on its way.

Iain

 

[rogerbh]

Sure, you can send it at rogerbh@yahoo.com.

 

[gwkenny]

Please post the resolution. Sounds very interesting!

Would very much appreciate it, thanks!

 

[Barrie Davidson]

The workbook was protected. No word yet if he's got the password to the workbook.

 

[ihmunro]

Hi Barrie

Try 27RL

Iain

 

[Barrie Davidson]

Hi Barrie

Try 27RL

Iain

Didn't work for me.

 

[ihmunro]

Hi Barrie

I guess the file needs to be run with the vba password software on the PC.

 

[Barrie Davidson]

Were you able to unhide the worksheet once you unprotected the workbook?

 

[ihmunro]

Hi Barry

Still no luck.