In Excel, is there an After Save event?

Posted on 2001-08-16
Medium Priority
Last Modified: 2012-06-21
There's a "Workbook_BeforeSave" event  in Excel that can be trapped to run some VBA code.  Is there any way to do the equivalent _after_ a Save has been completed?
Question by:EDC
  • 3
LVL 13

Accepted Solution

cri earned 800 total points
ID: 6393229

Author Comment

ID: 6398792
Just what I wanted!  Thanks!
LVL 13

Expert Comment

ID: 6399786
ThAnk you.

Expert Comment

ID: 13543235
The link to the page http://www.rb-ad.dircon.co.uk/rob/excelvba/tips/index.htm does not work anymore. Has anyone got this solution available?
LVL 13

Expert Comment

ID: 13587273
Rob Bruce seems to have disappeared. All refering links I managed to find in the net are as dead as the a.m. link. He is also not listed under http://www.mvps.org/links.html#Excel anymore. Hope he is well.

As for your question and future users:
The main trick is to use Application Level Events. See http://www.cpearson.com/excel/appevent.htm

If you need more, please ask.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
With the emergence of Office 365 as a superior email communication platform, many organizations have started switching over to it.  After migrating to Office 365, sometimes users, as well as organizations, will have to import PST files to Office 36…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question