ActiveWorkbook.Close
 

Can the ActiveWorkbook.Close event be modified so that the Save dialogue
box comes up?
Thanks in advance.

Matthew Saxon

ActiveWorkbook.Close
 

"Matthew" wrote in message
...
Can the ActiveWorkbook.Close event be modified so that the Save
dialogue
box comes up?
Thanks in advance.

Matthew Saxon

Sorry, so that the Save dialogue box does NOT come up...

ActiveWorkbook.Close
 

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

Matthew wrote:

"Matthew" wrote in message
...
Can the ActiveWorkbook.Close event be modified so that the Save
dialogue
box comes up?
Thanks in advance.

Matthew Saxon

Sorry, so that the Save dialogue box does NOT come up...

ActiveWorkbook.Close
 

You only get the save Dialog if the file is not saved yet.

Do you mean Save as???


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Matthew" wrote in message ...
Can the ActiveWorkbook.Close event be modified so that the Save dialogue
box comes up?
Thanks in advance.

Matthew Saxon

ActiveWorkbook.Close
 

No, I already did a save as text file, but when I close the file it asks to
save again for some reason.

MS


"Ron de Bruin" wrote in message
...
You only get the save Dialog if the file is not saved yet.

Do you mean Save as???


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Matthew" wrote in message
...
Can the ActiveWorkbook.Close event be modified so that the Save dialogue
box comes up?
Thanks in advance.

Matthew Saxon