Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hide a worksheet so that a macro can still find it
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? |
#2
|
|||
|
|||
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide AutoShapes On Excel Worksheet | Excel Worksheet Functions | |||
Cannat paste that macro formula onto a worksheet | Excel Discussion (Misc queries) | |||
how to find and replace a symbol in my worksheet | Excel Discussion (Misc queries) | |||
Making Find go through worksheet only once | Excel Discussion (Misc queries) | |||
How do I find a Macro in Excel when I don't know its name? | Excel Discussion (Misc queries) |