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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> > > news:(E-Mail Removed)...
> > > > 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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
> > >
>