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]


hammer wrote:
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