personal.xls locked for editing
 

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.

personal.xls locked for editing
 

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

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

personal.xls locked for editing
 

Gaetan

Only a problem if you have more than one instance of Excel running.

What is the purpose for that?


Gord Dibben MS Excel MVP

On Wed, 31 Jan 2007 08:40:00 -0800, Gaetan
wrote:

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

personal.xls locked for editing
 

Personally, I don't directly edit my macros in my personal.xl* file. I
experiment in another workbook. When I'm happy, I'll put the new/updated macro
into my personal.xl* file.

Since I don't do this very often, I can make sure that the file is not marked
readonly and I only have one instance of excel open.



Gaetan wrote:

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


--

Dave Peterson