98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Event Marco, VBA
Event Marco, VBA
Resolved · Medium Priority · Version 2007
Thu 21 Aug 2008, 15:33Delegate 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:20Trainer 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 information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Highlighting a data rangeAttempting 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! |
