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

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

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