Macro Can Run, But I Cannot Edit
 

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
ToolsMacro, 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

--
C Hon
-----------------------------------------------------------------------
C Hong's Profile: http://www.excelforum.com/member.php...fo&userid=1585
View this thread: http://www.excelforum.com/showthread.php?threadid=27346

Macro Can Run, But I Cannot Edit
 

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