Error when using IDE commands

[Peter Ostermann]

Hi folks,

using Excel 2000 allows to use the following code
(which is quite helpful during developement)
when opening and closing the workbook.

Sub OpenMainWindow()
With Application.VBE.MainWindow
.Visible = True
.SetFocus
End With
End Sub

Sub CloseMainWindow()
Application.VBE.MainWindow.Visible = False
End Sub

Running the same application using Excel 2003 this
code creates errors.

Are there any infos or known workarounds
concerning this problem?

Regards
Peter Ostermann

 

[Doug Glancy]

Peter,

In Excel (not in the VBE) choose Tools - Macro - Security - Trusted
Publishers, check "Trust Access to Visual Basic Project".

hth,

Doug