MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Difficult Question: Modifying Setting of VB Editor with Macro!


Posted by Akf on August 02, 2001 11:07 AM


Friends,

Is it possible to create a Macro that changes settings
in the VB Editor?

I would like a Macro that changes the color of the fonts
used in the VB Editor.

Might sound a little strange, I know, but I'm looking
for a way to "hide" the code in the VB Editor without
using a Password.

Anyways, thanks for all your help!



Posted by Jerid on August 02, 2001 12:23 PM


I don't think it's possible.

Jerid

Posted by Akf on August 02, 2001 2:14 PM

Thanks Anyway!

Jerid:

I knew that it was perhaps a little too much to
ask, but had to try...

Thanks,

Posted by Ivan F Moala on August 02, 2001 7:54 PM

Re: Thanks Anyway!

Is is possible through API's BUT this changes your system colours as well.

You could do it via send keys BUT the it will only
apply to new text and not any current module
text.

Code ???


Ivan

Posted by Jerid on August 03, 2001 6:09 AM

Re: Thanks Anyway!

After reading Ivan's message, I thought well maybe I didn't look for a solution hard enough, so I opened the VBE, clicked on Tools, Options, and clicked on the Editor Format Tab.

I changed the Foreground and Background colors to be the same color, then I started typing some code, while you are typing you can't see anything, BUT as soon as you hit <Enter> the VBE changes the color of the text back to black. So I think that this rules out the SendKeys option.

I also changed the system colors, this works for everything but the VB Key words, you know the words that VB changes automaticly to blue. So I think rules out the API.

Sorry, I think your best bet is the password.

Jerid

Posted by Ivan F Moala on August 03, 2001 7:34 AM

Re: Thanks Anyway!

Your best bet is to protect it...but you can still
change the background defaults ALL to auto this
includes the Keyword text and comments text then
change the background color to white and the
default text colour to white Via API's......
wouldn't do this myself BUT it can be done.


Ivan After reading Ivan's message, I thought well maybe I didn't look for a solution hard enough, so I opened the VBE, clicked on Tools, Options, and clicked on the Editor Format Tab. I changed the Foreground and Background colors to be the same color, then I started typing some code, while you are typing you can't see anything, BUT as soon as you hit <Enter> the VBE changes the color of the text back to black. So I think that this rules out the SendKeys option. I also changed the system colors, this works for everything but the VB Key words, you know the words that VB changes automaticly to blue. So I think rules out the API. Sorry, I think your best bet is the password. Jerid : Is is possible through API's BUT this changes your system colours as well. : You could do it via send keys BUT the it will only

Posted by Akf on August 06, 2001 7:46 AM

Re: Thanks Anyway!


Ivan and Jerid:

Thanks for all your time and help.

I was trying to find alternatives to a Password,
but it seems that not using one will be more
complex than I hoped for.

Thanks again!!!