set up a command button or macro for open file to "save as"

I have a workbook that uses many macros. I like to create a macro within a
form that allows user to "save as" file before exiting excel.


Thanks,
Mo

Hello Mo,

Do the following to display the Save As dialog whenever the Workbook is closed...

1) Select the Macro code and press CTRL + C to copy it
2) Open your Workbook
3) Press ALT + F11 to open the VBE
4) Press ALT + R to display and activate the Project Explorer
5) Press T, ThisWorkbook should be highlighted, if not, Click on it
6) Press CTRL + V to paste the Macro code
7) Press CTRL +S to save the macro

Please Login or Register  to view this content.

Sincerely,
Leith Ross