VBA Editor
 

Why macro dont work in Excel 2003

Application.VBE.MainWindow.Visible = True

Pierre

VBA Editor
 

Pierre,

Have you set a project reference to...
"Microsoft Visual Basic For Applications Extensibility" library?

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Pierre" wrote in message
Why macro dont work in Excel 2003
Application.VBE.MainWindow.Visible = True
Pierre

VBA Editor
 

Not necessary.

Pierre, in what context do you have that code?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Jim Cone" wrote in message
...
Pierre,

Have you set a project reference to...
"Microsoft Visual Basic For Applications Extensibility" library?

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Pierre" wrote in message
Why macro dont work in Excel 2003
Application.VBE.MainWindow.Visible = True
Pierre

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

VBA Editor
 

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.

It's working now.

Thanks,

Pierre