+ Reply to Thread
Results 1 to 3 of 3

Block Worksheet_Change part of the time?

  1. #1
    Registered User
    Join Date
    06-14-2004
    Posts
    52

    Block Worksheet_Change part of the time?

    When Cell C7 is changed, it calls on the Private Sub Worksheet_Change(ByVal Target As Range) Macro.

    Is it possible to block this macro during a particular other Macro's operation?

    If so how would I go about it?

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Yes,

    Application.EnableEvents = False

    Don't forget to renable in your code after the change is made.

  3. #3
    Registered User
    Join Date
    06-14-2004
    Posts
    52

    Duh !

    Thanks jason, the line as true was in the Private Sub too.


    I placed it where it need to be, worked great!

+ Reply to Thread

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