hide a worksheet so that a macro can still find it

[frendabrenda1]

Good morning.

I am trying to hide worksheets (preferably very hidden) that my macro must
find. Every time I hide the sheets the macro quits working because it can't
find the sheet. Is there a way to hide the sheets frmo a user, but allow the
Macro to find it?

[Ron de Bruin]

Hi frendabrenda1

You can't select cells on a hidden sheet or activate/select it
but you can change values without selectiing.

For example this will work if the sheet is hidden or not
Sheets("Sheet1").Range("A1:D5").Value = "ron"


--
Regards Ron de Bruin
http://www.rondebruin.nl


"frendabrenda1" <[email protected]> wrote in message
news:[email protected]...
> Good morning.
>
> I am trying to hide worksheets (preferably very hidden) that my macro must
> find. Every time I hide the sheets the macro quits working because it can't
> find the sheet. Is there a way to hide the sheets frmo a user, but allow the
> Macro to find it?