Solved

In Excel, is there an After Save event?

Posted on 2001-08-16
5
924 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
IF OR formula Excel 8 42
Need a poor man's PowerPoint 5 75
Office 365 vs. In-House 4 81
Recover lost Hyperlink destination/target in OneNote 3 30
Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful …
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: …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now