Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to run an After Save event?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save As Event | Excel Programming | |||
Example After Save Event | Excel Programming | |||
After Save Event help | Excel Programming | |||
save as event | Excel Programming | |||
After save event | Excel Programming |