| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply a macro to only one sheet
I have a workbook and have written a macro to hide certain rows in one
worksheet upon opening the file. It is an Auto_Open macro. However, it also hides the same rows in another sheet and in any new sheets I add to the workbook. QUESTION: How do I get the macro to be applied to only one sheet? -- Marc |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Apply a macro to only one sheet
On 3 Jan., 03:35, Marcus Analyst
wrote: I have a workbook and have written a macro to hide certain rows in one worksheet upon opening the file. It is an Auto_Open macro. However, it also hides the same rows in another sheet and in any new sheets I add to the workbook. QUESTION: How do I get the macro to be applied to only one sheet? -- Marc Hi Marc How are you referring to the sheet? sheets(1).range.... or Sheets("Sheet1").range... Show us the code. //Per |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Apply a macro to only one sheet
Post the code you are now using and someone can tell you what you need to
change. "Marcus Analyst" wrote: I have a workbook and have written a macro to hide certain rows in one worksheet upon opening the file. It is an Auto_Open macro. However, it also hides the same rows in another sheet and in any new sheets I add to the workbook. QUESTION: How do I get the macro to be applied to only one sheet? -- Marc |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Apply macro to one sheet only | Excel Discussion (Misc queries) | |||
| how do I apply changes I make on one sheet to other sheets? | Excel Discussion (Misc queries) | |||
| apply a macro to all sheets except for a certain sheet | Excel Discussion (Misc queries) | |||
| Apply same template to other sheet | Excel Programming | |||
| How do I apply LTRIM to entire Sheet? | Excel Programming | |||
Hybrid Mode
