There are no hidden sheets. I used a macro.

here is is:

Sub abc()
For Each sh In ActiveWorkbook.Sheets
sh.Visible = xlSheetVisible
Next
End Sub

--
Regards,
Tom Ogilvy


"sdubose99" wrote:


Thank you very much for the replies -- can you or someone suggest a
macro to accomplish that?

Scott


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