Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chantilly, VA USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stop Excel Document Properties Dialog Box from Opening

    Someone in my office has helpfully created an Excel form where every time I open the file the Document Properties box appears. I don't want to edit the Properties and I'm tired of dealing with it every time I use the form. How do I reverse engineer this so this doesn't open on Open?

    thanks

    Don

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Don,

    Open the VB editor by pressing Alt-F11 and double click ThisWorkbook in the VBA project pane. If there is code there, look for the line indicated in blue and place an apostrophe in front of the line. The line will turn green. Save and restart.

    Change:
    Code:
    Private Sub Workbook_Open()
    Application.Dialogs(xlDialogProperties).Show
    End Sub
    To:
    Code:
    Private Sub Workbook_Open()
    'Application.Dialogs(xlDialogProperties).Show
    End Sub
    If you are referring to the document Panel, uncheck the box that opens it on startup and save

    Document Panel.png

    HTH,
    Maud

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chantilly, VA USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Maud: Thanks... there's no code, so it must be the second option you offered. I don't see that particular document panel, and the one that pops up doesn't have a checkbox as in your example above. The one I get looks like this

    Document Properties Box.JPG

    How do I get to the properties box you showed?

    Thanks much for the help,

    Don

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Don,

    You will find it on the Developer Tab

    document panel.png

    HTH,
    Maud

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chantilly, VA USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts
    And the varmit has coded it so the check box is greyed out!

    But now I know where to look!

    thanks

    Don

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Don,

    Enter the following code into the ThisWorkbook module. Access the module using the instructions I provided in my first post. Check for a similar line of code equaled to True elsewhere in the sheet modules along with standard modules if any. in other words, double click anything in the VB project window and look for code.

    HTH,
    Maud

    Code:
    Private Sub Workbook_Open()
    Application.DisplayDocumentInformationPanel = False
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •