Results 1 to 9 of 9
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stupid Reviewing Toolbar (Excel 2002)

    I hate the <img src=/w3timages/censored.gif alt=censored border=0> reviewing toolbar that always pops up when I open an attached spreadsheet. How do I kill it stone dead.

    And while I'm listing my hates:

    - how do you disable the F1 help key, I sometimes press it by mistake when reaching for F2, and the whole thing grinds to a halt while help loads
    - how do I get security and calculation settings to stick (and over-ride the corporate selections)
    - what is happening to my file explorer - when I expand the C: drive, it takes about 90 seconds of serious disk werring before it displays anything (not really excel but I'm on a roll now)
    - I'm sick and tied of this office and when are we going to get a fine day and what is the use of complaining anyway ...
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Stupid Reviewing Toolbar (Excel 2002)

    1. If you mean when opening an Excel Workbook from Outlook, I don't get the review toolbar in Office 2003. See if, in your Outlook menu, Tools | Options | E-Mail Options | Advanced E-mail Options UNchecking (Unticking) "Add Properties to Attachments to enable Reply With Changes" helps. You may need to close and restart Outlook for this to take effect. Menu is from Outlook 2003, but I think it's the same in XP.

    2. Try typing without the boxing gloves. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> What will you do when you really want Help?

    3. Try setting things the way you want in all spreadsheets in your XLSTART Folder, including personal.xls. Otherwise you may have to talk to your Admin about these; they should stick unless you are forced to reload defaults every time Excel is opened.

    4. Talk to System Admin.

    5. Move. Or, assuming your are a transplanted <img src=/S/aussie.gif border=0 alt=aussie width=21 height=22>, at least explore the rest of the US. The bits south and west of you.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stupid Reviewing Toolbar (Excel 2002)

    1- You will need to use a VBA routine to disable the F1 key. The VBA Sub below should disable the F1 key:

    <pre>Public Sub NoF1()
    Application.OnKey "{F1}", ""
    End Sub
    </pre>


    If you want it disabled every time you use Excel, they you could put that like of code in the Workbook Open event routine in Personal.xls.

    2- It depends on what IT is doing to make them unsticky. Unless the IT folks are not very sharp, you probably can't. In any event, doing so might solve your fourth problem. The calculation setting is not something that IT would try to control. Can you be more specific on what is happening with it.

    3- You will need to ask this question in the appropriate Windows forum.

    4- It is a beautiful day here. Breaking IT's security settings might give you the opportunity to move somewhere else.
    Legare Coleman

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stupid Reviewing Toolbar (Excel 2002)

    To your top hate:

    Open the visual basic editor (alt-F11)
    Open the immediate pane (Control-g)
    type this line:
    application.CommandBars("Reviewing").Enabled=false
    Make sure your cursor is in that line and hit enter.

    To get the blasted bar back, repeat the above with True at the end of the line.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stupid Reviewing Toolbar (Excel 2002)

    1. item unchecked already - grrr

    2. Arrg - now why didn't I think if that. The other option is to get a bigger keyboard. Re help, I can always fall back on Help, Contents and Index on the menu bar.

    3. I'll try that and see what happens.

    5. Transplanted via the UK - it was more a 'continuation on a theme' item - see except from Monty Python skit ...

    M: I want to complain.
    C: You want to complain! Look at these shoes. I've only had them three weeks and the heels are worn right through.
    M: No, I want to complain about...
    C: If you complain nothing happens, you might as well not bother.
    M: Oh!
    C: Oh my back hurts, it's not a very fine day and I'm sick and tired of this office.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  6. #6
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stupid Reviewing Toolbar (Excel 2002)

    Thanks for all the good info. It took me a while to figure out your comment re IT security and #4. What I actually what to do is RAISE the security from NIL (where macros run no questions asked) to MEDIUM (where I get asked).

    Re calc - I would like it to set it to manual for some workbooks and stay manual for them. On others (smaller ones), automatic is fine. I bet you are going to tell me that that setting is excel related and not workbook related.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  7. #7
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stupid Reviewing Toolbar (Excel 2002)

    Right - the next time that stupid bar sets up, I'll be ready - locked and loaded!
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stupid Reviewing Toolbar (Excel 2002)

    That is how it works on my XL2K system. The Calculate property is saved with the worksheet. If I open a workbook, set calculate to manual, and save the workbook, then the next time I open the workbook calculation is set to manual. Is that now what happens on your system?

    If IT has not locked your security setting, you should be able to go to Tools/Macros/Security and change the setting. It should stick after you set it.
    Legare Coleman

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stupid Reviewing Toolbar (Excel 2002)

    Excel has the unpleasant habit that Calc is set by the FIRST workbook that has been opened. SO if you open a workbook that has set calc to auto and then one that has it set to manual, it stays auto. And vice versa.

    If you have a workbook that needs calc to be always manual, you need some code in it's Open event.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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