Personal.xlsb

[Noz2k]

Is there a way to make this into a shared workbook so that I don't get the readonly prompt when I have more than 1 instance of excel open at the same time?

 

[RoryA]

You can set its IsAddin property to True, though its macros will not then appear in the macros dialog, if that's how you normally run them.

 

[Noz2k]

That's fine, I don't really use it to be fair.

How do I set it's IsAddin property?

 

[RoryA]

Select its ThisWorkbook object in the Project Explorer and then in the properties window (f4 if that's not visible) set it to True.

 

[Noz2k]

Thanks Rorya,

Have given it a try, but it doesn't seem to be saving. As soon as I reopen a workbook the property seems to have returned to false.

tried entering workbooks("personal.xlsb").save in the command window but it still doesn't seem to have saved the new property.

Any idea?

 

[RoryA]

Do you only have one instance of Excel open when you are saving it?

 

[Noz2k]

Yeah, just the one

 

[RoryA]

It should work then, unless your file is read-only for some reason.

 

[Noz2k]

Don't think that it is.

In fact I think if it was readonly it would solve the problem, as I wouldn't get the prompt asking to start it in read only.


Is there a way to remove it, as I don't use it anyway.

 

[RoryA]

Close Excel, locate it in your XLSTART folder and delete it.