Hiding the Visual Basic Editor (Excel 2003)

Topic

New Reply

Version edited by HansV – the question is about Excel 2003, not 2000

I have been using the following to hide the VBE. but now I find that it hangs in xl 2003, even though it seems to be in the object model on a machine I checked that was running 2003.

Any clues why or any workaround?

If Val(Application.Version) =>9 Then
        .VBE.MainWindow.Visible = False
End If

Thanks

Reply | Quote

Replies

Is this code within a block

With Application
…
End With

If so, you can use .Version instead of Application.Version. If not, what does the . in .VBE refer to?

PS What is the purpose of this code? It only closes the Visual Basic Editor, the user can still use Alt+F11 to open it again.

Reply | Quote

Just my ,
Watch out for the operators order….If Val(Application.Version) =>9 Then… should be >=9

Reply | Quote