View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Edwin Tam[_7_] Edwin Tam[_7_] is offline
external usenet poster
 
Posts: 94
Default Help unhide sheets

In that Excel file, there is absolutely no hidden sheet. There is one and
only one worksheet (, and nothing is "xlveryhidden").

Regards,
Edwin Tam

http://www.vonixx.com


"William Horton" wrote:

Perhaps the sheets visible property got changed to X1VeryHidden. If that is
the case you can only unhide the sheet using a macro. Format / Sheet /
Unhide won't work in that case.

"sdubose99" wrote:


Hi there... I'm not an expert and got into a mess with one of my files.
I intentionally hid certain sheets but now can't unhide them. I've
unprotected my workbook, gone into VBA but can't see the other sheets
to unhide them. There should be one other sheet called 'Constants'.

I've uploaded the file 'here '
(http://s32.yousendit.com/d.aspx?id=1...737WJKVNM1EZ1U)

Can anyone offer any suggestions or help?

thank you,
Scott


--
sdubose99
------------------------------------------------------------------------
sdubose99's Profile: http://www.excelforum.com/member.php...o&userid=27538
View this thread: http://www.excelforum.com/showthread...hreadid=532981