Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wetherby, Yorkshire, England
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Echo Off (xl 2k)

    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

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Echo Off (xl 2k)

    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

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wetherby, Yorkshire, England
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Echo Off (xl 2k)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •