View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ram B Ram B is offline
external usenet poster
 
Posts: 16
Default Hide VB Scripts & macro from user

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