Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Anderson, Indiana, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reviewing Toolbar (2002 SP3)

    I am sure it is something simple that I am not getting. I have tried several methods found in the forums on how to keep the reviewing tool bar from being visible when opening an Excel workbook. I have not figured it out yet. Any help would be very appreciated on what I am doing wrong with the attached file. I also left in the different ways that I tried. So there will be some redundant lines of code in the modules.

    Thank You,

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reviewing Toolbar (2002 SP3)

    Ah, no that persistent thing is a pain!

    I put this one line code and attached to a toolbar button to get rig of it. Or you could assign a keyboard shortcut.

    <code>
    Sub HideReviewBar()
    Application.CommandBars("Reviewing").Visible = False
    End Sub
    </code>

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reviewing Toolbar (2002 SP3)

    The Workbook_Open procedure should be in the ThisWorkbook module if you want it to be executed automatically. It won't be executed automatically if you put it in a standard module or in a class module.

  4. #4
    2 Star Lounger
    Join Date
    Mar 2005
    Location
    Anderson, Indiana, USA
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reviewing Toolbar (2002 SP3)

    Thanks for the replies, it works just fine now.

Posting Permissions

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