Hi.
On my excel project, I am trying to create a macro which allows a user to save a spreadsheet.
WHat happens, is that i do not want the user saving the actual excel program (because it is a template), so I have created a 'Save' Macro, which copys the relevant information that they would want to save, and then creates a new workbook, and pastes the stuff in there.
Then, i want this workbook to popup a 'Save as' box.
THe reason why i can't do it, is because when i go to record a macro, it doesn't let me stop the macro when the 'save as' box is up. It only lets me stop it when i have either saved, or when I have clicked cancel.

So basically, i need the code to popup a save as box in excel, haha

Thanks for your help guys.

-AJ