Worksheet Macros for All Worksheets in a Workbook?

B

Bob

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
 
R

Ron de Bruin

Hi Bob

There is a Change event for example in each worksheet module but
if you go to the thisworkbook module there is a event called

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

End Sub

This will run on very change in all worksheets
 
Top