+ Reply to Thread
Results 1 to 2 of 2

Reviewing toolbar won't go away

Hybrid View

tcowen Reviewing toolbar won't go... 10-25-2006, 09:12 AM
VBA Noob Hi, Try this VBA code ... 10-25-2006, 01:27 PM
  1. #1
    Registered User
    Join Date
    03-08-2004
    Posts
    12

    Reviewing toolbar won't go away

    How can I turn off the Reviewing toolbar so that it doesn't come up every time I open Excel? I've looked under Options, nothing there. I've tried using the View:Toolbars:Customize but it doesn't stay. Do I need to create a startup template?

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    Try this VBA code

    Open a new workbook


    Alt-F11
    Insert>Module from the menubar
    paste the sub in there
    Alt-Q to go back to Excel


    If you do Alt-F8 you get a list of your macro's
    Select "test" and press Run


    Sub test()
    Application.CommandBars("Reviewing").Enabled = False
    End Sub


    Close the workbook (don't save it)


    VBA Noob

+ 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