freeze user

A

Annika

I have a macro in Excel that takes 5 minutes to execute.
Is there a way that I can prevent the user from using the
keyboard and/or from clicking on stuff in the worksheet
with their mouse?

This would keep the computer working on the macro instead
of being distracted by any impatient users trying to make
things run faster by clicking on everything they see.

I thought I read once that you could do this, but I can't
remember.
Any help you can offer would be great.
 
C

Chip Pearson

Annika,

See the Interactive property.

Application.Interactive = False
' your code here
Application.Interactive = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

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

Protection on Worksheets 5
how do I open a hyperlink with the keyboard only (not using mouse) 5
Freeze Pane Macro 1
what keystokes do i use to move from 1 worksheet to another? 2
Is there a keyboard shortcut to fill handle a large # of cells? 1
Stepping in to a cell 3
Keep macros from being ran under the tools option in the menu bar 3
Copying parts of a sheet with macro 7

Top