save changes

[leighmills33]

Hi guys is there a way to eliminate the option

"do you want to save changes you have made"

This is because i have a save button so i dont want to use this option, i also have a close button which is

"Application.quit"

But from doing this it asks me
"do you want to save changes you have made"

So can i get rid of this guys.

Thanks

Leigh

[shg]

Try

Please Login or Register  to view this content.

[mrice]

Try

Please Login or Register  to view this content.

which fools Excel into believing that its already saved and doesn't therefore need to ask the question.

[martindwilson]

look here
http://support.microsoft.com/kb/213428

[leighmills33]

ok thats cool thanks guys, another ask is when i use this to save
Application.GetSaveAsFilename
It doesnt seem to be working, it brings up the window but when i save it doesnt seem to work

[shg]

Please start a new thread with your new question.