View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Change VBE Settings

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