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

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