Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict Recorded Macro to a Particular Worksheet
Recorded macros seem to be available in every worksheet. Is there a way I can
restrict them to a particular worksheet |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Restrict Recorded Macro to a Particular Worksheet
I'm not sure if you can make them not show in the macro list but you
can check the active sheet at the start of a macro like this Sub Macro1() If Not (ActiveWorkbook.Name = "YourWorkbook.xls" _ and ActiveSheet.Name = "YourWorksheet") Then Exit Sub 'Your Code End Sub Charles Chickering Invoice wrote: Recorded macros seem to be available in every worksheet. Is there a way I can restrict them to a particular worksheet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Recorded macro | Excel Discussion (Misc queries) | |||
How to FIX Recorded Macro | Excel Discussion (Misc queries) | |||
Recorded Macro | New Users to Excel | |||
Creating a macro which presses a button containing a recorded macro | Excel Programming |