Open Only one Excel file in Excel Instance.
Posted on 2012-08-21
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.