Sheets("name of hidden sheet").Visible = True will unhide the sheet
you need to alter. Then when you have finished making changes:

Sheets("name of hidden sheet").Visible = False will hide the sheet
again


--
krabople
------------------------------------------------------------------------
krabople's Profile: http://www.excelforum.com/member.php...o&userid=29774
View this thread: http://www.excelforum.com/showthread...hreadid=494898