Close button X

julenshaun

New Member
Joined
Nov 16, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,119,137
Messages
5,576,299
Members
412,716
Latest member
Ardin
Top