Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Effects of certain code on file(s) being closed
Using Office 2003 and Window XP;
If the following are set in a file as it closes: Application.DisplayAlerts = False Application.EnableEvents = False 1. Will this affect the saved file in any way the next time it is opened? 2. Will it affect any other currently open files in the same instance? Thanks much for your assistance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Effects of certain code on file(s) being closed
These are application settings. They're not stored with any workbook.
The .displayalerts will stay false until you change it or the code ends. (Although, I've always toggled it back to True when I wanted it true.) The .enableevents setting will stay off (or on) until you change it (or close the excel application and reopen it). So the .displayalerts =false probably won't have any effect on any other workbook. But the .enableevents=false would stop any event from firing in any workbook that's currently opened (or even opened later). This can be a useful setting -- if that's what you really want. XP wrote: Using Office 2003 and Window XP; If the following are set in a file as it closes: Application.DisplayAlerts = False Application.EnableEvents = False 1. Will this affect the saved file in any way the next time it is opened? 2. Will it affect any other currently open files in the same instance? Thanks much for your assistance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA Key-Code Effects Rendered by vbKeyLButton | Excel Programming | |||
How to change closed file name - Error: file not found | Excel Programming | |||
Excel is not asking to save a changed file when the file is closed | Excel Discussion (Misc queries) | |||
VBA - on a button event, open another closed file, post changes, close file | Excel Programming |