Firstly, I am a very new macro writer so please be patient!

I have written a very simple macro to save the current work sheet an
then quit excel if no other files are open:

Sub saveandquit()

ActiveWorkbook.Save
ActiveWorkbook.Close

If IsEmpty(ActiveWorkbook) = True Then
Application.Quit
Else
Application.WindowState = xlMinimized
End If

End Sub

The problem being that I can't (i.e. don't want to) store the macro i
my personal.xls file. If the macro is saved in the worksheet when th
macro shuts the worksheet, it effectively shuts itself and therefor
doesn't run the rest of the code.

Can I save the macro separately and then call it from a specifie
location or is there a better way to do what I am trying to do?

Thanks,

Davi

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements