Opening Personal.xlsb Read Only if Necessary

[kozelibe]

Hello,

I can't find a previous post on this issue, but it must be a common problem.

I have several Excel macros that are set up to run periodically as a scheduled tasks. They work fine unless I have another instance of Excel open. In that case, Excel informs me that my personal.xlsb file is already open and gives me the option to open it read only or not open it at all (cancel). In either case the macros then run correctly.

Is there a way to automatically open personal.xlsb if another instance of Excel is already open so I don't have to go through this manual process? Is there a better way to accomplish the same thing?

Thanks,

Brian

 

[taigovinda]

Hi Brian,

One way to handle this is to put just one workbook into the scheduler, then in the open event of that workbook, have it open each of the other workbooks in succession (and let them run their code, then close them). That way you do all of your work from one Excel session. Matter of fact, I guess I'm kind of surprised that they are all opening up from separate sessions anyhow...

I'm not sure if you can make your personal open read-only, unless you maybe locate it in the windows explorer and set its file properties to always open read-only (right-click the file and check the "read only" box).

Tai

 

[SidBord]

Why are you using Personal.xlsb instead of Personal.xlsm??

 

[kozelibe]

Hello,

Personal is in the XLSTART folder. If you make is a .xlsm file then a new worksheet won't open when you lanch excel. It was what my IT group told me to do and it fixed the issue.

Brian