No Messages when quitting

[Kempes]

Hi all,

Is there a way to tell excel not to prompt for "Do you want to save changes, blah blah blah").

I just want to spreadsheet to be closed without prompting.

Many thanks
Kempes

 

[chergh]

application.displayalerts = false

 

[Kempes]

thanks. I'll give that a go.

also, I've played around with another save option for when i do want the user to save a copy. For this I used Application.GetSaveAsFilename, which gives the save window and looks like it has worked, but the file has not been saved down.

any ideas?

 

[chergh]

Yep read the helpfile. Here's how it begins:

GetSaveAsFilename Method

Displays the standard Save As dialog box and gets a file name from the user without actually saving any files.

Have a look at the "saveas" and "savecopyas" methods instead.

 

[Kempes]

got it.

used the above as a string, then put this string in the saveas method to trigger the full save as process.

Thanks for your help.

Kempes