Unhide sheets
 

Hi!
What code do I use to Unhide mutiple sheets rather than one at a time?
I've tried sheets("sheet1", "sheet2").Visible = True it does'nt work.
Thanks for any help


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=484052

Unhide sheets
 

Good evening Brian Matlack

These three lines should do the trick.

For Each Sht In ActiveWorkbook.Sheets
Sht.Visible = True
Next Sht

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=484052