OK.

Your first post stated the workbook was "not shared or protected" so we did not
look at that aspect at all.

Thanks for posting the result.


Gord

On Thu, 25 Oct 2007 18:18:01 -0000, wrote:

On Oct 25, 1:38 pm, wrote:
When I click on the project in the Project Explorer window of VBE I
get a "Project Locked" Dialogue Box and the message "Project is
unviewable" No password dialogue comes up and I am certain he has not
set a password to lock?? Any thoughts?

On Oct 25, 1:08 pm, Gord Dibben <gorddibbATshawDOTca wrote:

Have you clicked on your workbook/project in the Project Explorer window of the
VBE?

You will probably get a password dialog because the project is locked for
viewing.

Supply a password to unlock.

Gord Dibben MS Excel MVP

On Thu, 25 Oct 2007 16:25:49 -0000, wrote:
I am assisting a customer running Excel 2003 on a Windows
2K system. He has lost the ability to edit macro on a file he created.
From the Tools Macro Macros screen, the only buttons available are
run & cancel. Everything else is grayed out. I tried editing the macro
from Visual Basic -Tools-Macros- same issue. It isn't a protected or
shared worksheet. Any ideas?

Thanks.

ok, problem solved. He had turned on "highlight changes" under track
changes. This option shares the worksheet. Macros can't be edited in a
shared worksheet.

~AJS