Hide Macro

Hi everyone,

I was wondering... is there any way to "hide" the macros in a workbook? The current workbook passes through a couple of hands, and each person has a specific role. The first person inputs information, and runs a couple of macros, which manipulates the information and prints out certain pages for them. The person then e-mails the workbook to the next person, who adds some more information to the different areas of the same sheets, and runs a different set of macros.

Is there any way (besides asking them nicely) to make sure that the first person does not use the macros that are meant for the second person? If the first person goes into Tools>Macros, they can see and run any macro contained in the workbook.

Thank you for your time!

Hi,

1.Option Private Module for the Macros not to appear in Tools Macro ...

2. Add a password to your project ... nobody will get into code ...

HTH
Carim

Thank you so much, Carim!

That is exactly what I needed!

Glad your problems are fixed.

Thanks for the feedback

Carim