| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking the excel running the macro
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Locking the excel running the macro
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running a macro outside of Excel | Excel Programming | |||
| Macro keeps locking up Excel 97 | Excel Programming | |||
| Running a excel macro from VB6 | Excel Programming | |||
| Launch Macro in Access via Macro running in Excel??? | Excel Programming | |||
| Running Excel Macro from VB6 | Excel Programming | |||
Linear Mode
