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.