How to make a sheet the active sheet?
 

If the user is on sheet 3, and I want the macro to be applied to sheet
2, how can I get the macro to make sheet 2 the active sheet?

tia

How to make a sheet the active sheet?
 

worksheets("sheet2").Activate


or
Application.Goto Reference:=Worksheets("Sheet2").Range("A1")



or you can just refer to Sheet2 and not make it the active sheet

With Worksheets("Sheet2")
.Range("A1").Value = 7
.Range("A1:A10").Interior.ColorIndex = 5
End with

as an example.

--
Regards,
Tom Ogilvy

wrote in message
...
If the user is on sheet 3, and I want the macro to be applied to sheet
2, how can I get the macro to make sheet 2 the active sheet?

tia