Event Marco, VBA

Resolved · Medium Priority · Version 2007

Thu 21 Aug 2008, 15:33 Delegate Alix said...

Alix has attended:
Excel VBA Intro Intermediate course

Event Marco, VBA

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?

Wed 17 Sep 2008, 10:20 Trainer Laura said...

RE: Event Marco, VBA

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips