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


Code:
--------------------
Private Sub Workbook_BeforeClose(Cancel As Boolean)

Application.Dialogs(xlDialogSaveAs).Show

End Sub
--------------------


Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=381425