Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA Programs Run on a Locked PC
I have a Excel VBA program that requires around 10 hours of run time.
It accesses multiple files and extracts data. I would like to lock my PC while the PC is running. The program runs fine as long as I don't lock (ctrl-alt-del-enter) the PC. I've tried inserting the LockWorkStation function (see below) in various spots in my code which does lock the PC but the program still stops running. Private Declare Function LockWorkStation Lib "user32.dll" () As Long Does VBA only run on an unlocked PC? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA Programs Run on a Locked PC
Most keyboard commands will not interfere with a running macro. A hand lettered sign placed on the computer, with a date, stating that a program is running should prevent interruption by co-workers. However... The Application.Interactive property may do what you want or even the Application.EnableCancelKey property. Be careful what you wish for. <g Not much can prevent someone, up to no good, from cutting off the power. -- Jim Cone Portland, Oregon USA "Wayne" wrote in message I have a Excel VBA program that requires around 10 hours of run time. It accesses multiple files and extracts data. I would like to lock my PC while the PC is running. The program runs fine as long as I don't lock (ctrl-alt-del-enter) the PC. I've tried inserting the LockWorkStation function (see below) in various spots in my code which does lock the PC but the program still stops running. Private Declare Function LockWorkStation Lib "user32.dll" () As Long Does VBA only run on an unlocked PC? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can VBA Programs Run on a Locked PC
haha nice jim.
on the same train of thought, you might as well unplug your monitor. if it looks broken, nobody will use it. "Jim Cone" wrote: Most keyboard commands will not interfere with a running macro. A hand lettered sign placed on the computer, with a date, stating that a program is running should prevent interruption by co-workers. However... The Application.Interactive property may do what you want or even the Application.EnableCancelKey property. Be careful what you wish for. <g Not much can prevent someone, up to no good, from cutting off the power. -- Jim Cone Portland, Oregon USA "Wayne" wrote in message I have a Excel VBA program that requires around 10 hours of run time. It accesses multiple files and extracts data. I would like to lock my PC while the PC is running. The program runs fine as long as I don't lock (ctrl-alt-del-enter) the PC. I've tried inserting the LockWorkStation function (see below) in various spots in my code which does lock the PC but the program still stops running. Private Declare Function LockWorkStation Lib "user32.dll" () As Long Does VBA only run on an unlocked PC? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
where do you put programs? | Excel Programming | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
I want the macros to be locked up when cells are locked up. | Excel Programming |