Macro screen- everything but Run and cancel is greyed out
 

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.

Macro screen- everything but Run and cancel is greyed out
 

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.

Macro screen- everything but Run and cancel is greyed out
 

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

" 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.

Macro screen- everything but Run and cancel is greyed out
 

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.

Macro screen- everything but Run and cancel is greyed out
 

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

Macro screen- everything but Run and cancel is greyed out
 

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


On Thu, 25 Oct 2007 17:38:50 -0000, 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.

Macro screen- everything but Run and cancel is greyed out
 

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