View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
PhilosophersSage PhilosophersSage is offline
external usenet poster
 
Posts: 55
Default 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!