Hide VB Scripts & macro from user

[Ram B]

Is there a way to prevent the user from viewing VB scripts and Macros. The
reason I ask is that I have a protected sheet and I have passowrds coded into
the scripts that I want to prevent the user from seeing.

eg.
Sub auto_open()
With Worksheets("Passive Safety")
.Protect Password:="password", userinterfaceonly:=True
.EnableOutlining = True
End With
End Sub

 

[NateBuckley]

In the VBA window, go to VBAProject Properties and then the tab named
"Protectioon and add a password.

When you next reload the excel file you will not be able to get access to
the macros without the password, or a cracking plug in. But for basic
security it does the trick.