Hidden sheets and macros

[mwc0914]

I have a macro that references some data on a sheet I wish to have
hidden in my workbook. The macro abends because the sheet is hidden. Is
there some way to reference the hidden sheet in the macro so it will
execute?

 

[colofnature]

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

 

[Guest]

ActiveCell.Formula = "=+MyHiddenWorksheet!B2"

--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.