-
Hi Anonymous! This is how I would add a new worksheet and attach the "Calulate" event handler (the example shows a message box each time the calculate event is triggered): Private Sub NewSheet_Click() Dim oXl As Application: Set oXl = Application oXl.EnableEvents = False oXl.DisplayAlerts ...
-
Could you not use a hidden worksheet, hidden with the xlSheetVeryHidden attribute, so your users cannot see it in the UI and add this sheet, with the calculate event code already in it, maybe by menu or button. It would be far simpler than trying to write code into the worksheet object. If that is at...