+ Reply to Thread
Results 1 to 2 of 2

Control automatic runs of macros

  1. #1
    Forum Contributor
    Join Date
    12-02-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    112

    Question Control automatic runs of macros

    Hi,

    There is a following code:

    MACRO1

    Please Login or Register  to view this content.
    And the file "FIRST\GRAND EVALUATIONS.xlsm" has got the following code:

    MACRO2

    Private Sub Workbook_Open()

    Please Login or Register  to view this content.
    Here, whenever a file "FIRST\GRAND EVALUATIONS.xlsm" is opened, it runs a macro2 . But I would like to control the running of that macro, so that it runs only when it is told to do so.

    Please provide me with some solutions to control that macro2 from regular RUNS.

    Thanks

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Control automatic runs of macros

    The issue is the Macro Name

    Workbook_Open or Auto_Open will run the macro as soon as the workbook is open. So change the name.

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro Runs IN Debug but Not In Automatic
    By SteWilf in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2015, 02:41 AM
  2. Making a macro that runs other macros
    By worthm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-31-2014, 05:34 PM
  3. [SOLVED] What goes between 2 macros so one runs right after the first?
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-08-2012, 01:34 AM
  4. How to make WebBrowser control display different HTML files on subsequent macro runs
    By VTHokie11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2012, 09:34 AM
  5. Excel runs really slow after macros. help!!
    By excelnoobie123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2010, 04:35 AM
  6. If then statement to control when the script runs
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2009, 06:42 PM
  7. [SOLVED] Showing MsgBox after Control Toolbar macro runs
    By Don Wiss in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2006, 09:05 PM

Tags for this Thread

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