• Hiding the Visual Basic Editor (Excel 2003)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Hiding the Visual Basic Editor (Excel 2003)

    Author
    Topic
    #420638

    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

    Viewing 1 reply thread
    Author
    Replies
    • #953052

      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.

    • #953325

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

    Viewing 1 reply thread
    Reply To: Hiding the Visual Basic Editor (Excel 2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: