Locking User Interaction
 

Hi All,

What is the VB code for locking user interaction with the workbook while
certain macros are running? I have a few macros that need to be on specific
sheets of the workbook. If macro is runnig and users change the worksheets,
my macros do not work since they need to be on specific worksheet for
processing. I need to freeze the excel window or something while macros are
running. How can you lock up user interaction with the excel workbook while
macros are running?

I tried using the following VB code which does not do the trick:
Application.ScreenUpdating = False
Application.EnableEvents = False

Even I tried changing the shape of cursor to xlwait which did not work!!!!

Thanks