| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro with hidden sheets
Hi,
I've just finished setting up my spreadsheet and starting hiding sheets that users don't need to see, and I have a macro that no longer works since hiding the sheet. The code is: Sheets("BINDING").Select Is there any way I can still use this macro but hide the sheet? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running a macro with hidden sheets
Try to change Select with Activate:
Sheets("BINDING").activate "JonathanW" wrote: Hi, I've just finished setting up my spreadsheet and starting hiding sheets that users don't need to see, and I have a macro that no longer works since hiding the sheet. The code is: Sheets("BINDING").Select Is there any way I can still use this macro but hide the sheet? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running a macro with hidden sheets
Hi Jon,
You cannot select or activate the hidden object, but you can change the sheets contents by code. Just like: Sheets("BINDING").Range("A1").Value = "TestValue" Altough Sheets("BINDING") is hidden. -- Regards, Halim "JonathanW" wrote: Hi, I've just finished setting up my spreadsheet and starting hiding sheets that users don't need to see, and I have a macro that no longer works since hiding the sheet. The code is: Sheets("BINDING").Select Is there any way I can still use this macro but hide the sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running code on hidden sheets (revisited) | Excel Programming | |||
| Running code on hidden sheets | Excel Programming | |||
| hidden rows when running a macro | Excel Programming | |||
| Running a Macro from hidden Workbook | Excel Programming | |||
| running macros on hidden sheets? | Excel Programming | |||
Linear Mode
