Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |