Solved

In Excel, is there an After Save event?

Posted on 2001-08-16
5
925 Views
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?
0
Comment
Question by:EDC
  • 3
5 Comments
 
LVL 13

Accepted Solution

by:
cri earned 200 total points
ID: 6393229
0
 

Author Comment

by:EDC
ID: 6398792
Just what I wanted!  Thanks!
0
 
LVL 13

Expert Comment

by:cri
ID: 6399786
ThAnk you.
0
 

Expert Comment

by:chriscboy
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?
0
 
LVL 13

Expert Comment

by:cri
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.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

786 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