Apply a macro to only one sheet

's Computer Specifications

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

's Computer Specifications

On 3 Jan., 03:35, Marcus Analyst
<MarcusAnal...@discussions.microsoft.com> 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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
RE: Apply macro to one sheet only	CLR	Microsoft Excel Misc	4	3rd Jan 2008 10:14 PM
RE: Apply macro to one sheet only	Gary''s Student	Microsoft Excel Misc	1	3rd Jan 2008 10:13 PM
Re: Apply macro to one sheet only	Sandy Mann	Microsoft Excel Misc	1	3rd Jan 2008 10:13 PM
Taking one value sheet 1 and apply to sheet 2	join_the_band	Microsoft Excel Discussion	2	8th Jun 2006 02:09 AM
apply a macro to all sheets except for a certain sheet	minrufeng	Microsoft Excel Misc	4	22nd Feb 2006 02:53 PM