gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 348
- Office Version
- 365
- Platform
- Windows
- Mobile
I've built a workbook that has 3 mandatory worksheets in it, and they should always be the first three in the sheet index. This is easy enough to accomodate for when a new sheet is created, but I'm having trouble determining how to intercept these incoming sheets should the user decide to place the newly moved sheet before the mandatory ones. The only events that trigger are Workbook Deactivate & Workbook Window Deactivate, but neither have parameters that will take a sheet.
Any ideas? Thanks.
Any ideas? Thanks.