Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Oct 2002
    Location
    Boca Raton, Florida, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stop bringing up the Review Toolbar (Excel 2002)

    Stumped I am. I cannot stop the Review Toolbar from coming up when I open up an Excel sheet sent from someone who has the Toolbar on. I can go to the View Menu and turn it off but I do not want to have to do that almost every time I open a spreadsheet. Does anyone know how to disable a Default Toolbar permanently? I never use the Review toolbar so if it means making it inaccessible that's OK. It is just so annoying when you get your Menus and Toolbars etc, all set the way you want them and then someone sends you something and forces their settings on you.... it just ain't right I tell ya... grumble, grumble..... <img src=/S/bouncenburn.gif border=0 alt=bouncenburn width=31 height=31>

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

    Re: Stop bringing up the Review Toolbar (Excel 2002)

    Unfortunately, Microsoft seems to have decided that the Reviewing toolbar can't be banished. You can create a macro to disable it temporarily, but it'll pop up again after a while. The right combination of garlic, wooden stakes etc. has not yet been found...

    Here is the macro:

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

    You can assign this macro to a custom toolbar button and/or a keyboard shortcut for ease of use, and you can call it from the Workbook_Open event procedure in the ThisWorkbook module in your Personal.xls macro workbook.

  3. #3
    New Lounger
    Join Date
    Oct 2002
    Location
    Boca Raton, Florida, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stop bringing up the Review Toolbar (Excel 2002)

    Well... thanks for your help Hans. When you say that it will pop up again after a while... do you mean while working on the same spreadsheet? I really wish Microsoft would allow us to make our own intelligent choices...... even if they're not good choices at least they are our own and then there is no one to blame but ourselves! Thanks again!

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

    Re: Stop bringing up the Review Toolbar (Excel 2002)

    It probably won't appear while working in the same spreadsheet, but it may when you open another one, especially if you received it via e-mail.

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stop bringing up the Review Toolbar (Excel 2002)

    I had a post last summer about having a macro available for any file I should open, without having to copy the macro (which put my favorite page footers in position for any wb.) A "Class" module-based solution was recommended, and it worked. Could that approach be used here? I am in the exact same boat as the writer and am looking to suppress that toolbar. Thanks.

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

    Re: Stop bringing up the Review Toolbar (Excel 2002)

    If you have applied the technique, you already have a class module in your Personal.xls or in an add-in with a variable defined as

    Public WithEvents myApp As Application

    Of course, you may have another name than myApp. You can create a WorkbookOpen event handler for this variable, or add code to it if you already have such an event handler:

    Private Sub myApp_WorkbookOpen(ByVal Wb As Workbook)
    CommandBars("Reviewing").Enabled = False
    End Sub

    For others reading this: the class module and the variable need to be initialized. Say that the class module is named Class1. Put the following declaration in a standard module:

    Public MyClass As New Class1

    And in the Workbook_Open event handler in the ThisWorkbook module of the workbook containing the code:

    Private Sub Workbook_Open()
    Set MyClass.myApp = Application
    End Sub

  7. #7
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stop bringing up the Review Toolbar (Excel 2002)

    So what's the advantage of making a class in this case, why not just call 'CommandBars("Reviewing").Enabled = False' in the workbook _open event? <img src=/S/confused.gif border=0 alt=confused width=15 height=20> I've written my own classes before but haven't used the WithEvents modifier. I can understand if you want to call this more than once, but in this case it's just used once.

    Thnx, Deb

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

    Re: Stop bringing up the Review Toolbar (Excel 2002)

    The Workbook_Open event only applies to the workbook that contains the code, so you would have to put a Workbook_Open event procedure in all your workbooks.

    By using application-level events, you can put the code in one workbook (for example your Personal.xls, or in an add-in) and it will work for all workbooks you open.

  9. #9
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stop bringing up the Review Toolbar (Excel 2002)

    Aaaahhhh, I get it <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22> . I now know why I never used it because I always write Excel apps for others to use so I would never add code to personal.xls since I'd have to add it to their personal.xls and that's not possible (my users are potentially everyone who buys our products).

    Thnx, Deb

  10. #10
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stop bringing up the Review Toolbar (Excel 200

    Presumably, however, there's nothing stopping you putting it into an Add-In - if those are part of what you supply.
    Gre

Posting Permissions

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