Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable user interaction in VBA
Hi All,
How can you disable user interaction with a workbook while awaiting completion of running of a few macros? These macros depend on specific selection of worksheets and if users change the worksheet tabs, they will break the macros. How can I disable their user interaction with workbook while macros are running? I tried the followings which failed: - changing the cursor shape to xlwait - Application.ScreenUpdating = False Application.EnableEvents = False thanks for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable user interaction in VBA
Write your macro code to be independent of selection:
Instead of Worksheets("Sheet1").Select Range("A12").Select MyVal = Selection.Value use MyVal = Worksheets("Sheet1").Range("A12").Value Post your code if you need help doing so. HTH, Bernie MS Excel MVP "LABKHAND" wrote in message ... Hi All, How can you disable user interaction with a workbook while awaiting completion of running of a few macros? These macros depend on specific selection of worksheets and if users change the worksheet tabs, they will break the macros. How can I disable their user interaction with workbook while macros are running? I tried the followings which failed: - changing the cursor shape to xlwait - Application.ScreenUpdating = False Application.EnableEvents = False thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking User Interaction | Excel Programming | |||
How Email does not need user interaction ? | Excel Discussion (Misc queries) | |||
Worksheet copy without user interaction | Excel Programming | |||
Upload file without user interaction - VBA | Excel Programming | |||
Modeless form for user interaction | Excel Programming |