Thread
:
Hiding VB Code
View Single Post
#
7
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Hiding VB Code
Pretty simple..
At the top of the module put
Option private module
and they can't see it from toolsmacros
type option private module as the top line in the module. Same as typing
private sub thissub() for each
Now goto toolsmacrosmacros and you will not see your macros anymore.
To work in the module comment out the line and then uncomment when through
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"johnsail" wrote in message
...
Hi Don
Don't understand what you mean here. Can you explain a bit further please.
John
"Don Guillett" wrote:
At the top of the module put
Option private module
and they can't see it from toolsmacros
Also, protect the macro project to deny access to most people.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett