Echo Off (xl 2k)

Topic

New Reply

In Access code you set echo off with the DoCmd command so that actions are carried out without having to see it all. Is there some way of doing this in Excel? I can’t find anything.
Thanks.
Peter Herworth

Reply | Quote

Replies

In VBA you can use Application.ScreenUpdating = False to switch off screen activity, and when you need to show the updated screen use Application.ScreenUpdating = True.

Or if you wish to supress ssytem messages you can use Ap[plication.DisplayAlerts = False, and reverse similar to above.

Andrew C

Reply | Quote

Andrew
That did it for me. Thanks a lot.
I really should have been able to find that for myself. Perhaps this forum makes it too easy for us – but it is a great help.
Thanks again.
Peter Herworth

Reply | Quote