View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default 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