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!
|