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
Application.GetSaveAsFilename but just unsure how to get it to work on the x close button