still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 774
- Office Version
- 365
- Platform
- Windows
Hi hope all are healthy
I made a toggle button to disable events (or enable events) on a spreadsheet to NOT run (or run) an event marco.
I deleted the spreadsheet and all macros for it. when i didn't need the sheet any more
Then I couldn't get any Private Sub Workbook_open()>>Private Sub Workbook_activate() to work in any workbooks,
or Private Sub Worksheet_open()>>Private Sub Worksheet_activate() in any sheets
I put >>>Application.EnableEvents = True in the workbook that the sheet came from and now all events in all books work.
I'm wondering what I did wrong when I deleted the toggle button and all the macros with it.
I did press the button a few times to remind me what it did before i deleted it
mike
I made a toggle button to disable events (or enable events) on a spreadsheet to NOT run (or run) an event marco.
I deleted the spreadsheet and all macros for it. when i didn't need the sheet any more
Then I couldn't get any Private Sub Workbook_open()>>Private Sub Workbook_activate() to work in any workbooks,
or Private Sub Worksheet_open()>>Private Sub Worksheet_activate() in any sheets
I put >>>Application.EnableEvents = True in the workbook that the sheet came from and now all events in all books work.
I'm wondering what I did wrong when I deleted the toggle button and all the macros with it.
I did press the button a few times to remind me what it did before i deleted it
mike