MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Locking window whilst running macro.


Posted by David Hill on October 17, 2001 1:24 PM

How do I lock the current window whilst a macro is running.

This was possible in Lotus 123 with what I remember as the
Panelon panel off command.

Can you do the same in Excel 2000

Thanks for reading so far and your reply.

David


Posted by Leroy on October 17, 2001 11:13 PM

David,

Have you tried using Application.ScreenUpdating = False or Application.Interactive = False in your macro?