Chris,

I believe that is because the code in the Visual Basic Editor - VBE - is protected.
You will have to go into the VBE - Alt + F11 - and double click on the workbook name in
the left hand pane. You will be prompted to enter the password.

Regards,
Jim Cone
San Francisco, CA

"C Hong" wrote in message ...

Hello, any advice on this topic would be helpful.
I received an Excel 97 file that contains macros. I have no problem
running the macros, but when I try to edit them by going to the
ToolsMacro, I only have the option to "Run" or "Cancel". There are
several macro titles in the scroll box. All the other buttons are
greyed out and cannot be pressed.
I'm pretty sure that this is due to some sort of protection. However,
I am never promted to enter any protection information.
Thanks, I appreciate any help.
Chris