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