Sean,
There are VBA code obfuscators. Here's one with some discussion:
http://www.dailydoseofexcel.com/arch...visible-basic/

NickHK

"Sean" wrote in message
ups.com...
Thanks Peter

I have code that inserts a module in ThisWorkbook, which is then
e-mailed out. What I would like is if this code (created via code) is
then changed to white font within the ThisWorkbook. I have no way of
protecting the vba via code as the module itself creates a dummy file
to be e-mailed out and as I understand from the NG's you can't protect
vba via code, my alternative is to just create a 'tiny' obstacle for
the user if they get nosey


Peter T wrote:
You could change font colour in your own VBE, Tools Options General
and
perhaps with an appropriate addin in user's too (though I'd regard that
as a
virus!).

You can protect code in your project with a password, right click the
project name properties protection. Whilst, as I gather, that
wouldn't
deter many round here it would probably hide code from most casual
users.

Regard,
Peter T


"Sean" wrote in message
oups.com...
Is it possible to change the font colour of Text in Excel VB editor
(completely) to white?

This may seem strange but its just a basic way to hide code from eyes
(i.e. create another obstacle) as you can't protect via code the vba


Thanks