+ Reply to Thread
Results 1 to 3 of 3

How do I stop Toolbar from automatically showing up?

  1. #1
    Wendy - Payroll
    Guest

    How do I stop Toolbar from automatically showing up?

    Excel 2003 - The Reviewing Toolbar always shows up when starting a new
    workbook. Is there a way to stop that? I never use the toolbar and it takes
    up space.

  2. #2
    Lisa Beach
    Guest

    Re: How do I stop Toolbar from automatically showing up?

    Go to View Menu, select Toolbars and uncheck the toolbar you don't want to
    view.




    "Wendy - Payroll" <Wendy - [email protected]> wrote in
    message news:[email protected]...
    Excel 2003 - The Reviewing Toolbar always shows up when starting a new
    workbook. Is there a way to stop that? I never use the toolbar and it
    takes
    up space.



  3. #3
    Gord Dibben
    Guest

    Re: How do I stop Toolbar from automatically showing up?

    Wendy

    A recent posting from Jim Rech addresses this.

    Jim post..................

    If the workbook is sent as an attachment to Outlook then File, Properties
    are automatically added which will make the Reviewing toolbar appear when
    the workbook is opened in Excel. I don't know of a way to stop this.

    However, once you open the workbook in Excel you can remove these properties
    and save the workbook. After that it will no longer cause the reviewing
    toolbar to appear. Here's an old message on that:

    --------------

    The Reviewing toolbar in Excel pops up whenever you open a workbook that has
    been emailed from within Excel "for review". There may be other ways to
    make this happen too. If you do a File, Properties you'll see the custom
    file properties that have been added that triggers this.

    You can kill the added file properties manually or run the below macro to do
    it. This macro is in my Personal and attached to a toolbar button because I
    feel the same way as you about this toolbar.

    --
    Jim Rech
    Excel MVP

    Sub KillReviewingCustProps()
    Dim x As DocumentProperties
    Dim Counter As Integer
    Set x = ActiveWorkbook.CustomDocumentProperties
    For Counter = x.Count To 1 Step -1
    If Left(x.Item(Counter).Name, 1) = "_" Then _
    x.Item(Counter).Delete
    Next
    CommandBars("Reviewing").Visible = False
    End Sub

    End Jim post.......................


    Gord Dibben Excel MVP

    On Thu, 6 Oct 2005 09:25:03 -0700, Wendy - Payroll <Wendy -
    [email protected]> wrote:

    >Excel 2003 - The Reviewing Toolbar always shows up when starting a new
    >workbook. Is there a way to stop that? I never use the toolbar and it takes
    >up space.



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1