Macro screen- everything but Run and cancel is greyed out

[Amanda.Solari]

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.

 

[Gord Dibben]

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

 

[Guest]

hi
can you edit directly in the vb editor?
Alt+F11 then brouse to project module.
I have no idea why the buttom on the macro screen is grayed out but try a
direct edit.

regards
FSt1

 

[Amanda.Solari]

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?

 

[Amanda.Solari]

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?

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

 

[Gord Dibben]

Sounds like the project was locked for viewing in a later version.

When you try to open in an earlier version you don't get the dialog for password
entry.

The only fix I know of is to open the workbook in the creating version then
remove the protection.


Gord

 

[Gord Dibben]

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