If you merely want to unhide all sheets, you can try:

Sub unhide_sheets()
Dim a As Object
For Each a In ActiveWorkbook.Sheets
a.Visible = True
Next
End Sub

But, if you apply the macro to the file you posted for us, you'll not find
the sheet called "constants" that you mentioned...

Regards,
Edwin Tam

http://www.vonixx.com


"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