A simple solution would be to make the sheet visible during execution of
the macro then hide it again at the end. Put this at the start of your
code:

application.screenupdating = false
sheets("TheHiddenSheet").visible = true

and this at the end:

sheets("TheHiddenSheet").visible = false
application.screenupdating = true

That way the sheet will be available to the rest of your macro, but the
user won't see it appear and disappear.

Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=558479