personal.xlsb locked for editing when i open a 2nd excel window

[regdent]

I have some macro's set up in my personal.xlsb file and i often like to open
2 windows rather thn having all of my excel documents open in one. but when i
open the 2nd program i get the file in use error and i cant use my macro's

Is there a way i can save my macro's better so this doesnt happen? Is there
any solutions apart from dont open a 2nd excel window.

Thanks in advance

 

[regdent]

I think i figured it out if i read only the file in windows explorer it
doesnt bug me, i just guess if i need to do another macro i will have to
uncheck read only

 

[Conan Kelly]

regdent,

I'm assuming that you are using XL 2007?

I do this often in XL 2003 (on Win XP Pro) and when I open the 2nd instance
of XL, it pops up a message telling me that it is already open/locked for
editing by myself and would I like to open it RO, be notified when it is
unlocked, or to cancel...just as if another user on the network had the file
open.

You would think that MS would carry this forward to XL 2007...guess not
(unless there is some way to enable it).

I'm wondering if you could create a macro that could save your personal
macro workbook (incase you made changes), set the RO attribute, and open a
2nd instance of XL. You could also try to get the macro to check the RO
attrib. and toggle it depending on its setting.

HTH,

Conan

 

[iliace]

I have some macro's set up in my personal.xlsb file and i often like to open
2 windows rather thn having all of my excel documents open in one. but when i
open the 2nd program i get the file in use error and i cant use my macro's

Is there a way i can save my macro's better so this doesnt happen? Is there
any solutions apart from dont open a 2nd excel window.

Thanks in advance

You can use the macros, you just can't save any changes you make to
them. Do that in the first instance of Excel.

Also, there's a difference between having two instances of Excel and
multiple windows in one instance of Excel. Under Office Menu -> Excel
Options -> Advanced -> Display, if you check "Show all windows in
taskbar", you will be able to have multiple files in different windows
from a single instance of Excel. In Excel 2003, this option is under
Tools -> Options -> View -> Show. This is less resource-intensive
than your alternative, since you don't have two Personal.xlsb files,
and whatever other add-ins you have installed.