Results 1 to 13 of 13

A function to replace all the application.screenupdating references

Threaded View

  1. #1
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    A function to replace all the application.screenupdating references

    Is there a method which could replace all of the numerous places in code in-which the code below is used? Maybe some type of function which is called instead of repeating the same code over and over or maybe this is the best method.

        With Application
            .ScreenUpdating = False
            .EnableEvents = False
            .DisplayAlerts = False
            .Calculation = xlCalculationManual
        End With
    Edit: Sorry posted in the wrong forum
    Last edited by jeffreybrown; 03-12-2011 at 05:30 PM.
    HTH
    Regards, Jeff

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1