Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limit Macro to Intended worksheet.
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Limit Macro to Intended worksheet.
one way:
Public Sub MyMacro If ActiveSheet.Name < "Safe" Then Exit Sub '<rest of your macro here End Sub In article , 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
limit on size of macro for excell97 | Excel Discussion (Misc queries) | |||
limit size of worksheet | Excel Discussion (Misc queries) | |||
Worksheet Limit | Excel Discussion (Misc queries) | |||
Worksheet Limit | Excel Discussion (Misc queries) | |||
macro to time limit workbook | Excel Discussion (Misc queries) |