Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro closes excel and therefore won't run anymore
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro closes excel and therefore won't run anymore
Thanks for that. That is a good way to work around the problem ------------------------------------------------ ~~ 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel never closes | Excel Discussion (Misc queries) | |||
Excel closes down during a macro | Excel Discussion (Misc queries) | |||
Macro Editor closes Excel 2000 ? | Excel Discussion (Misc queries) | |||
Making a macro run when the user closes a workbook | Excel Programming | |||
Making a macro run when the user closes a workbook | Excel Programming |