Locking the excel running the macro

[[email protected]]

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.

[[email protected]]

Any help will be appreciated.


[email protected] 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.

[NickHK]

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

<[email protected]> wrote in message
news:[email protected]...
> Any help will be appreciated.
>
>
> [email protected] 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.
>