running macros on hidden sheets?

[hammer]

Hi,
I have completed my project and have 6 hidden sheets but have macros running
off the main visible sheet that manipulate data on the hidden sheets,
everything runs ok with the sheets unhidden, but as soon as I hide the
sheets none of my macros work? How can I have the sheets hidden and still
have the macros functioning?

cheers

Jamie

--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://www.giantcompany.com

 

[Jake Marx]

Hi Jamie,

There are some things you can't do with hidden sheets. Namely select or
activate them. If you are using the Select or Activate method in your code,
you'll have to remove those. An example:

Sheets("Sheet1").Select
Sheets("Sheet1").Range("A1").Select
MsgBox Activecell.Value

becomes:

MsgBox Sheets("Sheet1").Range("A1").Value

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]