Open Only one Excel file in Excel Instance.

Posted on 2012-08-21
Last Modified: 2012-09-20
Hi Team,

I have a .xlsm file that opens up as soon as a person logs into the system and then the file will also hide itself.  The reason for this is becuase the file is suppose to keep running in the back end to track some data usage.

Now everything runs fine.   Till the time the user open another excel file.  Now the hide instance of my Excel sheet becomes visiable.

I want a way were once my excel file is opened and then hidden.  If any other Excel files are opened they should open in another Excel Instance.  This way my file is never discovered.

Question by:Sandesh555
    LVL 7

    Expert Comment


    Author Comment


    I want to do this only for one file.  That is my Excel automation File.  Rest all files should be able to open in the same instance other than the instance in which my Excel Automation file is open.

    For Example.

    Lets say my Automation file name is ExcelAutomation.xlsm and a few other reports file like Report.xlsx, Report1.xlsx etc.

    Now when the user logs in the ExcelAutomation.xlsm file will open automatically lets say in Instance A.  But when the user starts to open Report.xlsx this should open up in a differnt instance, lets say Instance B.  Now when the user goes to open Report1.xlsx.  this should open in Instance B so on.

    I hope I have made my self clear.  :)

    Sandesh Jadhav.

    Author Comment


    I dont want to disable this.  I only want my excel automation file to remain hidden and no other excel file should one in the instance my automation file is running in.
    LVL 31

    Accepted Solution

    This sounds similar to the situation with the Personal.xls file in Excel 2003 and earlier.

    I have my Personal.xls to open from the xlstart directory but it opens hidden. I can then open files in the same instance of excel and the personal.xls does not show itself.

    If I want to see the Personal.xls I can go to the Window menu and select Unhide, do what I need to and then Window > Hide. I guess you would have to add some protection so that the user cannot do this as well.

    Rob H

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now