In Excel 2003, I have macros in a particular file that have confidential
information that I don't want users to see. How can I hide and password
protect macros so they cannot be viewed by anyone except an authorized viewer
(i.e. me).

Thanks in advance for your help. This is an awesome Discussion Group (I'm
new to it)

Best Regards,

JAL

Tools - Options - Protection Tab. You can password protect your code in
that workbook. Have you thought about saving your project as an add-in
(.xla) file? Once an add-in has been compiled, you can't read the code.



"JAL" wrote:

In Excel 2003, I have macros in a particular file that have confidential
information that I don't want users to see. How can I hide and password
protect macros so they cannot be viewed by anyone except an authorized viewer
(i.e. me).

Thanks in advance for your help. This is an awesome Discussion Group (I'm
new to it)

Best Regards,

JAL

Should be Tools - VBA Project Properties - Protection.
--
HTH...

Jim Thomlinson


"Eric White" wrote:

Tools - Options - Protection Tab. You can password protect your code in
that workbook. Have you thought about saving your project as an add-in
(.xla) file? Once an add-in has been compiled, you can't read the code.



"JAL" wrote:

In Excel 2003, I have macros in a particular file that have confidential
information that I don't want users to see. How can I hide and password
protect macros so they cannot be viewed by anyone except an authorized viewer
(i.e. me).

Thanks in advance for your help. This is an awesome Discussion Group (I'm
new to it)

Best Regards,

JAL