MrExcel Publishing
Your One Stop for Excel Tips & Solutions

how do you stop the ontime macro application


Posted by lee on March 21, 2001 8:46 AM

I have a macro that uses the ontime application to run a certain macro at specific times during the day. The probelm occurs when I close the excel workbook prior to the last time the macro is supposed to run. When this occurs the macro still attempts to run at the specified times by opening the closed workbook. How do I have the macro stop running once the workbook is closed.


Posted by Celia on March 21, 2001 8:57 AM


Try this macro:

Sub FileInFooter()
ActiveSheet.PageSetup.LeftFooter = ActiveWorkbook.FullName
End Sub

Posted by Celia on March 21, 2001 9:06 AM


lee
Have a look at :-
Celia's Reply in 10038.html
Celia