View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gaetan Gaetan is offline
external usenet poster
 
Posts: 21
Default personal.xls locked for editing

One way or the other, this is a problem.

"Dave Peterson" wrote:

If you mark the file Readonly (using windows explorer), then you won't get the
message. But you won't be able to change the file in that state, either.



Gaetan wrote:

I've recently created macros in Excel that are stored in personal.xls. It
might be because it never happened that I opened two instances of Excel since
I've created these macros (although I doubt it), but every time I open two or
more instances of Excel, I get the message that the personal.xls file is
locked for editing by myself.

Is there a way to go around this or do I have to live with it, considering
that I need the macros to be available in all Excel files I open?

Thanks.


--

Dave Peterson