+ Reply to Thread
Results 1 to 2 of 2

VBA macro not running with excel file open

  1. #1
    Registered User
    Join Date
    09-14-2011
    Location
    Lausanne, Switzerland
    MS-Off Ver
    Excel 2013
    Posts
    18

    VBA macro not running with excel file open

    Hi everyone

    I am having problem with a vba code.
    I design a form, coded everything and it seems to work fine. When opening the file, the form is launching and excel is hidden.
    my code is:
    Please Login or Register  to view this content.
    It all works fine if I load the file without any other excel file open.
    Can anyone help me?

    Thanks

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,629

    Re: VBA macro not running with excel file open

    You did not post enough info, but you need something like:
    Private Sub workbook_Open()
    Application.Windows(Thisworkbook.Name).Visible = False
    FrmRapport.Show
    End Sub
    Ben Van Johnson

+ 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. Running workbooks.open to open pax-protected file still prompts for a password
    By karinincanada in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2015, 05:06 PM
  2. [SOLVED] Excel Hangs when running Macro unless resource monitor open on top of excel??????
    By JimBobBowie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2014, 10:55 AM
  3. Open another excel file while running macro
    By jai2808 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2013, 12:42 AM
  4. macro prompts immediately to open a file once the Excel file with the macro is opened
    By jhmayor03 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2012, 10:00 AM
  5. Excel Macro to open explorer, open csv file
    By Trubble in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-13-2009, 04:54 AM
  6. Running a macro on file open
    By emea training 2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2007, 06:23 AM
  7. [SOLVED] Excel 2003 - Keep a Macro Running While the Workbook is Open
    By MaxRoberts22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2006, 03:35 PM

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