Reopen workbook
This is working.
But each time I restart the tool I get this message
"The macro ,path and name!DummyMac, can' be executed. The macro is not
available etc...."
But the other macros or working .
Is it possible to disable this message
I've tried displayalerts = false but it returns anyway.
Weeepie
"Dave Peterson" schreef in bericht
...
Maybe you can use application.ontime to run a do-nothing macro. As long
as
excel is open (not necessarily your workbook), excel will reopen a
workbook to
run that macro.
Option Explicit
Sub testme()
Application.OnTime Now + TimeSerial(0, 0, 1), _
"'" & ThisWorkbook.Name & "'!DummyMac"
ThisWorkbook.Close savechanges:=False
End Sub
Sub DummyMac()
'uncomment this line for testing???
'MsgBox "hi"
End Sub
Depending on your security settings, you may get prompted to allow macros
to
open.
|