Event Marco, VBA

Resolved · Medium Priority · Version 2007

Event Marco, VBA

Alix has attended:
Excel VBA course

by - delegate Alix [4 posts] (2008 Aug 21 Thu, 15:33) Reply

Background: There is an event marco to prompt a msgbox to ask users for a comment log every time before close if there is a change to the files in excel file I am working work with.
I have to use write a marco to implement a change to all these files.

Question: how to skip event marco or having a marco to answer the msgbox pop from event marco, in order to deal with the msgbox?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Event Marco, VBA

by - trainer Laura silver contributer [86 posts] (2008 Sep 17 Wed, 10:20) Reply

The easiest way to do this is for all the event code that happens at the close of the file to be skipped. Before you close the file enter the line

Application.EnableEvents = False

and then after the close has happened its important to turn events back on.

Application.EnableEvents = True

Hope that helps.

Laura GB

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Microsoft Excel's Best Kept Secret
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Advanced level training: Microsoft Excel and the Web
· How Excel Training Can Improve Your Company's Sales Process

Please browse our web site to find out more about
microsoft excel training and other Microsoft training courses.

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips