Can VBA be used to change VBE settings? Specifically, how can syntax
checking be turned off and variable declaration turned on?

Cliff Edwards

The VBE programmability object model does not support changing VBE settings.
I think you'd have to investigate making the changes via registry entries.
The setting are stored under this key:

HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Commo n

--
Jim
"ward376" wrote in message
...
| Can VBA be used to change VBE settings? Specifically, how can syntax
| checking be turned off and variable declaration turned on?
|
| Cliff Edwards

There does not appear to be any exposed property you can change.

However you could add code to read/write 0/1 to
HKCU\Software\Microsoft\VBA\6.0\Common\RequireDecl aration

otherwise SendKeys

Regards,
Peter T



"ward376" wrote in message
...
Can VBA be used to change VBE settings? Specifically, how can syntax
checking be turned off and variable declaration turned on?

Cliff Edwards

:( Thanks!

Cliff Edwards