| 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? |
| 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 | |||
![Wayne[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
