Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Action after save
Is it possible to create an event after a save? I have a macro that runs
before a save to hide specific sheets and would like those sheets available after the save just as before. The reason I have this is a macro runs at open and user enters a password into user box, and depending on password it unhides specific sheets. I have tried Private Sub Workbook_AfterSave(Cancel As Boolean) Code End Sub But it does not work, any ideas are appreciated. Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Action after save
An interesting question. One option is to have the BeforeSave routine
schedule an clean-up macro (using OnTime). The clean-up macro would do the post-save actions. -- Gary''s Student - gsnu200908 "PhilosophersSage" wrote: Is it possible to create an event after a save? I have a macro that runs before a save to hide specific sheets and would like those sheets available after the save just as before. The reason I have this is a macro runs at open and user enters a password into user box, and depending on password it unhides specific sheets. I have tried Private Sub Workbook_AfterSave(Cancel As Boolean) Code End Sub But it does not work, any ideas are appreciated. Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Action after save
--Why dont you hide all sheets at Workbook open before prompting password and
based on password unhide the specific sheets --"and depending on password it unhides specific sheets." . To unhide these sheets at open the sheets should be hidden right??...but here you are asking to unhide --There is no event called AfterSave If this post helps click Yes --------------- Jacob Skaria "PhilosophersSage" wrote: Is it possible to create an event after a save? I have a macro that runs before a save to hide specific sheets and would like those sheets available after the save just as before. The reason I have this is a macro runs at open and user enters a password into user box, and depending on password it unhides specific sheets. I have tried Private Sub Workbook_AfterSave(Cancel As Boolean) Code End Sub But it does not work, any ideas are appreciated. Thank you! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Action after save
Thanks for the pointer, that is what I needed. I tried a call before but it
only prolong the save rather then running after save. "Gary''s Student" wrote: An interesting question. One option is to have the BeforeSave routine schedule an clean-up macro (using OnTime). The clean-up macro would do the post-save actions. -- Gary''s Student - gsnu200908 "PhilosophersSage" wrote: Is it possible to create an event after a save? I have a macro that runs before a save to hide specific sheets and would like those sheets available after the save just as before. The reason I have this is a macro runs at open and user enters a password into user box, and depending on password it unhides specific sheets. I have tried Private Sub Workbook_AfterSave(Cancel As Boolean) Code End Sub But it does not work, any ideas are appreciated. Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i undo an action after i have clicked save. | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
Action Pane is disabled when I save the document and reopen. | Charts and Charting in Excel | |||
Undo a save action | Excel Discussion (Misc queries) | |||
Excel 2002 crashing during "Save As" action. | Excel Discussion (Misc queries) |