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 ***