Thread: Hiding macros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Eric White Eric White is offline
external usenet poster
 
Posts: 1
Default Hiding macros

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