View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 2
Default Worksheet Macros for All Worksheets in a Workbook?

Hi,
I have written a group of worksheet macros (things like Private Sub
Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)).
I would like these macros to apply to all sheets in the workbook,
including ones that are addded later. How do I do this?

Thanks,
Andrew