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

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

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

What I would like is if this code (created via code) is
then changed to white font within the ThisWorkbook

Not possible, you'd need to program to user's vbe or registry (please don't
try!).

as I understand from the NG's you can't protect
vba via code,

You could search this group for something like "Bill-Manville lock
vbproject" which uses Sendkeys. Sendkeys of course is flunky, a while back I
tried to make it more reliable by changing passwords an automated instance
and ensuring the appropriate dialogs and msgbox's were on top and active at
the right times, but it's still SendKeys!

Regards,
Peter T

"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

Thanks Peter, I think I'll pass up on the idea!


Peter T wrote:

What I would like is if this code (created via code) is
then changed to white font within the ThisWorkbook

Not possible, you'd need to program to user's vbe or registry (please don't
try!).

as I understand from the NG's you can't protect
vba via code,

You could search this group for something like "Bill-Manville lock
vbproject" which uses Sendkeys. Sendkeys of course is flunky, a while back I
tried to make it more reliable by changing passwords an automated instance
and ensuring the appropriate dialogs and msgbox's were on top and active at
the right times, but it's still SendKeys!

Regards,
Peter T

"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

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