Consulting

Results 1 to 3 of 3

Thread: Solved: Disable Workbook_Open macro when opening another workbook

  1. 12-06-2005, 09:15 AM #1
    malik641
    malik641 is offline
    Administrator
    2nd VP-Knowledge Base     VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location

    Solved: Disable Workbook_Open macro when opening another workbook

    Hey guys

    Here's the deal.
    I have a procedure that opens another workbook to import data into it. It has a Workbook_Open event that I don't want to execute when it opens, how do I disable it???

    Thanks




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
    Reply With Quote Reply With Quote
  2. 12-06-2005, 10:10 AM #2
    mvidas
    mvidas is offline
    Knowledge Base Approver
    The King of Overkill! VBAX Master
    Joined
    Jul 2004
    Location
    Rochester, NY
    Posts
    1,727
    Location
    Hi Joseph,

    Application.EnableEvents is your friend here [vba] Dim WB As Workbook
    Application.EnableEvents = False
    Set WB = Workbooks.Open(WBPathAndName)
    Application.EnableEvents = True[/vba]Matt
    Reply With Quote Reply With Quote
  3. 12-06-2005, 11:06 AM #3
    malik641
    malik641 is offline
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    Awesome, forgot about that one!

    Thanks Matt




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules