View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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.