Limit Macro to Intended worksheet.
Make your macro sheet-specific.
Sub MyMacro()
Sheets("Sheet1").Activate
run the code
End Sub
Or.........................
With Sheets("Sheet1")
run the code
End With
Or.....................
Use worksheet_activate code in the sheet module
Private Sub Worksheet_Activate()
MyMacro
End Sub
Note: this last one will run the macro everytime the sheet is selected. May
not be what you need.
Gord Dibben MS Excel MVP
On Thu, 1 Mar 2007 18:01:10 -0800, Quin wrote:
Is there a way to limit a macro to work only on ONE work sheet? When I
record a macro I only see an option to store in a WORKBOOK but not a work
sheet.
The problem I have is my macro will distroy my worksheet if I hit the
shortcut key while the wrong worksheet tab is selected. With multiple macros
and multiple worksheets it is only a matter of time before I hit the shortcut
key and get unintended results!
Quin
|