M
Matthew
Can the ActiveWorkbook.Close event be modified so that the Save dialogue
box comes up?
Thanks in advance.
Matthew Saxon
box comes up?
Thanks in advance.
Matthew Saxon
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Matthew
Sorry, so that the Save dialogue box does NOT come up...Matthew said:Can the ActiveWorkbook.Close event be modified so that the Save dialogue
box comes up?
Thanks in advance.
Matthew Saxon
J
John Wilson
Matthew,
Two ways......
Application.DisplayAlerts = False
(turns off the alert)
or
ThisWorkbook.Saved = True
(fools the workbook into "thinking" that it's saved whether it is or
not).
Use just prior to your Activeworkbook.Close
John
Two ways......
Application.DisplayAlerts = False
(turns off the alert)
or
ThisWorkbook.Saved = True
(fools the workbook into "thinking" that it's saved whether it is or
not).
Use just prior to your Activeworkbook.Close
John
R
Ron de Bruin
You only get the save Dialog if the file is not saved yet.
Do you mean Save as???
Do you mean Save as???
M
Muusbreath
No, I already did a save as text file, but when I close the file it asks to
save again for some reason.
MS
save again for some reason.
MS