E
Elkar
Ok, I'm having trouble wrapping my brain around this one and could use some
help. I need to find a way to trigger an event automatically "after" a
workbook has been saved.
Here's basically what I want to accomplish. I want to make a workbook
unusable if Macros are not enabled. I've created a Message sheet that is set
to display upon opening. All other sheets are hidden. I then use the
Workbook_Open event to hide this Message sheet, and unhide the other sheets.
This all works fine.
The problem arises when the workbook is saved. I want to restore the
Message sheet, so the next time the workbook is opened, it will again display
if Macros are disabled. This also, I can do, but I also want to return the
user to their prior location after the save is complete so they can continue
working uninterrupted.
Any ideas would be appreciated. Thanks much!
Elkar
Using Excel 2003 SP2
help. I need to find a way to trigger an event automatically "after" a
workbook has been saved.
Here's basically what I want to accomplish. I want to make a workbook
unusable if Macros are not enabled. I've created a Message sheet that is set
to display upon opening. All other sheets are hidden. I then use the
Workbook_Open event to hide this Message sheet, and unhide the other sheets.
This all works fine.
The problem arises when the workbook is saved. I want to restore the
Message sheet, so the next time the workbook is opened, it will again display
if Macros are disabled. This also, I can do, but I also want to return the
user to their prior location after the save is complete so they can continue
working uninterrupted.
Any ideas would be appreciated. Thanks much!
Elkar
Using Excel 2003 SP2