personal.xls locked

B

Bill

I have a personal.xls that is hidden and is in the xlstart
folder so that I can have macros available to all
worksheets. When I click on excel and open another copy,
istead of using file open, it says the personal.xls is
locked. Can I get around that.

Thanks in advance
 
D

Dave Peterson

You're actually opening two instances of excel????

If yes, then I'd recommend only opening one--just because it makes life easier
(in lots of situations).

If you can't do this, then maybe:
save your personal.xls as an addin personal.xla
or
I think this works:
Windows|explorer
traverse to your XLStart folder
rightclick on personal.xls
Properties
Check the readonly box.

If you decide to make changes to this workbook, you'll have to go through minor
hoops to "un-readonly" the file.

(I like to make changes to my personal.xla file only after testing the code in a
separate file. Then I can drag the module into it later--and I don't have to
worry about losing any work.)
 
Top