Locking Code In Individual Macros
 

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

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

You can't protect one module and leave other modules unprotected in a single
workbook's project. But I guess I think I'd try to make the code more
bulletproof.

(I guess you could create two workbooks--protect one project and leave the other
project unprotected???)

I don't think there's a way to change the formatting for a single
module/procedure.

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

--

Dave Peterson