Close button X

[julenshaun]

I run the macros which work fine but what i am trying to do is once i have finished all i want to do and close the whole workbook, i click the x in the top right hand corner and you get a message box asking to save with the three options, well i want to change that so you have no options and it goes straight to the 'save as' part, i am trying with some VBA code:

Application.GetSaveAsFilename but just unsure how to get it to work on the x close button

 

[julenshaun]

Can anyone help it is really bugging me now