Sheets("sheet1").Visible = xlsheetvisible

or

Sheets("sheet1").Visible = True
try those...

roshinpp_77 Wrote:
Hi members,
Please let me know if anybody knew the opposite of xlVeryHidden.
I have made a sheet hidden using the below code.

Sheets("sheet1").Visible = xlVeryHidden


Now if want to make it visible, what is the macro to write.

Please advice..

Thanks

Roshi

--
pianoma
-----------------------------------------------------------------------
pianoman's Profile: http://www.excelforum.com/member.php...fo&userid=3371
View this thread: http://www.excelforum.com/showthread.php?threadid=54853