Macro Can Run, But I Cannot Edit

[C Hong]

Hello, any advice on this topic would be helpful.

I received an Excel 97 file that contains macros. I have no proble
running the macros, but when I try to edit them by going to th
Tools>Macro, I only have the option to "Run" or "Cancel". There ar
several macro titles in the scroll box. All the other buttons ar
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.


Chri

 

[Jim Cone]

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