View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Change VBE Settings

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