freeze user

  • Thread starter Thread starter Annika
  • Start date Start date
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.
 
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)
 
Back
Top