| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can a macro format a hidden sheet?
I have an open sheet, which is only open to record the macro. Then I hide
the sheet and use the keyboard shortcut to clear the hidden sheet. This won't work. I get an error in the Sheets("report").select area. Guessing because it can't select a sheet that it doesn't see. If I unhide the sheet, the macro works fine. How can I make this work and still have the sheet hidden? Also, what's the difference between hidden and very hidden? Thanks. |
|
#2
|
|||
|
|||
|
Robert,
Refer to the hidden sheet by it's name, such as 'Sheet1'. For example: Sheets("Sheet1").Range("A1:A16").ClearContents Hidden sheets can be seen from the FORMAT / SHEET / HIDE[UNHIDE] form. Very Hidden sheets can only be seen in the Visual Basic Editor. HTH, Gary Brown "Robert" wrote: I have an open sheet, which is only open to record the macro. Then I hide the sheet and use the keyboard shortcut to clear the hidden sheet. This won't work. I get an error in the Sheets("report").select area. Guessing because it can't select a sheet that it doesn't see. If I unhide the sheet, the macro works fine. How can I make this work and still have the sheet hidden? Also, what's the difference between hidden and very hidden? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format sheet data | Excel Worksheet Functions | |||
| 2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
| Macro, select Sheet "Number", NOT Sheet Name | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
| Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions | |||
Linear Mode
