Locking User Interaction

L

LABKHAND

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable user interaction in VBA 1
Need Help with Macro Security 1
VBA word change keys 0
Addin not allowing thisworkbook.save in before save event 3
Macro to Select text from a point given to a specific word 2
Word macro that can call cells out of Excel for a find and replace 0
security, enabling macros to enable a disabling saving function 12
excel internet explorer interaction appearance 3

Top