Thread: Hiding VB Code
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
johnsail johnsail is offline
external usenet poster
 
Posts: 38
Default Hiding VB Code

Hi Bob
Not sure what you mean here.
When I go into VBA project, ToolsProject Properties the project name
"VBAProject" is highlighted.
If i tyen go to protection and tick the box and enter a password it seems to
make no difference.

If I try to give the project a name it tells me that the name I have chosen
is not valid.
What am I missing?
Do I have to save the code in some special way?

John

"Bob Phillips" wrote:

Password protect the VBA project, ToolsProject PropertiesProtection

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"johnsail" wrote in message
...
How do you hide the VB code from users?
My sheet is protected but when you right click on the sheet tab and
select
View, you can see all the code - including the password that is
"protecting"
the sheet.

John