Dear Carl:

Why don't you put all your "protected code" in a Sub that will be stored in
a protected module? That way you can call the Sub from the Workbook_Open
event.

Hope this helps. Please rate this post.

G.Morales

"Carl Bowman" wrote:

Is there a way to lock one macro for viewing without affecting all macros in
the workbook? I need to protect the Workbook_Open macro but the user needs to
be able to view other macros for troubleshooting. If not, is there a way to
change the font color on only one macro?
Thanks