+ Reply to Thread
Results 1 to 5 of 5

Hidden Excel File opens when running Macros

  1. 08-22-2013, 11:18 AM #1
    mp4-4
    mp4-4 is offline
    Registered User
    Join Date
    11-19-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Hidden Excel File opens when running Macros

    I have 2 Excel files:
    File 1 is a dashboard where users can enter in data, and see results interactively.
    File 2 is hidden (VBA property) and contains macros that computes results for File 1.

    Data is moved from File 1 to File 2, and results are sent back from File 2 to File 1.
    For some reason File 2 becomes visible when its running its macros. It also becomes visible when the user attempts opening a spreadsheet: this due to the new spreadsheet running on the former instance of excel.

    I do not understand why File 2 appears when its running macros. Are there additional measures exist to ensure that my File 2 remains out of sight?
    Please advise.
    Reply With QuoteRegister To Reply
  2. 08-22-2013, 11:50 AM #2
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Hidden Excel File opens when running Macros

    Hello mp4-4,

    When you say "File" do you actually mean "Sheet", or are you talking about two seperate WorkBooks?

    We would have to see what the Code looks like, before we may be able to provide you with a ready solution.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  3. 08-22-2013, 11:56 AM #3
    Solus Rankin
    Solus Rankin is offline
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Hidden Excel File opens when running Macros

    Is the second file a personal.xlsb?
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."
    Reply With QuoteRegister To Reply
  4. 08-22-2013, 12:34 PM #4
    mp4-4
    mp4-4 is offline
    Registered User
    Join Date
    11-19-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Hidden Excel File opens when running Macros

    Winon, I have two separate Workbooks. Will try posting the relevant code.

    XeRo Solus, The 2nd file is a .xls, Im not sure how a .xlsb differs.
    Reply With QuoteRegister To Reply
  5. 08-22-2013, 12:45 PM #5
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Hidden Excel File opens when running Macros

    The "b" in the File Extension ".xlsb", means that the WorkBook has been saved in a Binary format.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macros not running unless Workbooks are opened with File>Open
    By Benjooster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2013, 11:02 AM
  2. Running macros including hidden worksheets
    By cbrow236 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-15-2013, 11:46 AM
  3. VBA in Word opens, closes Excel app but process still running in Task Manager
    By 6StringJazzer in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 02-16-2011, 09:10 AM
  4. [SOLVED] Running Macros without opening file.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2006, 02:56 AM
  5. [SOLVED] opening an excel file opens a duplicate file of the same file
    By skm in forum Excel General
    Replies: 1
    Last Post: 12-07-2005, 01:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1