Disable user interaction in VBA

[LABKHAND]

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.

 

[Bernie Deitrick]

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