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

Peter,

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

hth,

Doug


"Peter Ostermann" wrote in message
...
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