Guus2005
AWF VIP
- Local time
- Today, 02:58
- Joined
- Jun 26, 2007
- Messages
- 2,641
Hi there,
I have a workbook with 12 worksheets.
The code for every worksheet is the same. A subset:
In Access you can use WithEvents to group recurring pieces of code.
Is this also possible in Excel and if so, how?
Thanks!
I have a workbook with 12 worksheets.
The code for every worksheet is the same. A subset:
Code:
Private Sub Worksheet_Activate()
gstrPrevSheetName = ActiveSheet.Name
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
TabChange Target
End Sub
In Access you can use WithEvents to group recurring pieces of code.
Is this also possible in Excel and if so, how?
Thanks!