Thread
:
Locking the excel running the macro
View Single Post
#
3
Posted to microsoft.public.excel.programming
NickHK
external usenet poster
Posts: 4,391
Locking the excel running the macro
You can start you own instance of Excel that remains hidden eg.
Dim MyExcel As Excel.Application
Set MyExcel=New Excel.Application
....etc
MyExcel.IgnoreRemoterequests may be useful also.
NickHK
wrote in message
oups.com...
Any help will be appreciated.
wrote:
Is it possible to "lock" the excel running a starttimer macro so no
other workbooks can be opened until the stoptimer is run? I have a
starttimer that is to run for 4 hours every 5 minutes. I have noticed
that if I get something through email it will open in that application
and give me an error. Any help will be appreciated.
Reply With Quote
NickHK
View Public Profile
Find all posts by NickHK