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?
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
