ActiveWorkbook.Close

M

Matthew

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

Matthew Saxon
 
M

Matthew

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

Matthew Saxon
Click to expand...
Sorry, so that the Save dialogue box does NOT come up...
 
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
 
R

Ron de Bruin

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with ActiveWorkbook.Close command 3
Open workbook without running Workbook_Open Event 5
Macro to use an refresh a worksheet using an excel addin 0
Closing a file with macros 4
Create a dynamic master file 1
Function to perform on closing an Excel Workbook 4
Saving Workbook with Password using SaveChange 2
save and exit macro 8

Top