Thread: VBA Editor
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Shailesh Shah[_2_] Shailesh Shah[_2_] is offline
external usenet poster
 
Posts: 114
Default VBA Editor

From VBA Help:

A method or property can't be used because of security settings. For
example, the properties and methods of the VBE object for manipulating
the Microsoft Visual Basic for Applications (VBA) code stored in an
Microsoft Office document are inaccessible by default.
To turn on trusted access to Visual Basic Projects:

On the Tools menu, point to Macro, and then click Security.
On the Trusted Sources tab, select the Trust access to Visual Basic
Project check box.


Regards,
Shah Shailesh
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

*** Sent via Developersdex http://www.developersdex.com ***