Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Auditing Toolbar Disabled (V 9.0.2719)

    What setting(s) are unique to a spreadsheet (workbook) that would disable the Auditing toolbar in only that workbook? I use Auditing alot but have never encountered this before.

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

    Re: Auditing Toolbar Disabled (V 9.0.2719)

    Does the workbook contain macros? There could be code in the Workbook_Open and Workbook_BeforeClose events, or in the WorkBook_Activate and Workbook_Deactivate events to disable/enable a toolbar.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Auditing Toolbar Disabled (V 9.0.2719)

    No. There are no macros in this workbook. I copied this page from a workbook that does have macros, but in that workbook Auditing is Enabled. . . . I see now what happened. But that brings me to another question (probably simpler to answer).
    Yesterday, in this workbook, I created a cellnote to remind the next user of a worksheet tip. But since I've been using this pc only recently, I can't figure out how to get cell notes to disappear instead of staying open. So under Tools-Options-Objects I selected HideAll and sure enough, the cell note went away. What I didn't notice at that time was disabled Auditing. Had I realized all of that before, I would only have had to ask: How do I turn cell notes to disappear when you move the mouse-pointer away from the cell?

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

    Re: Auditing Toolbar Disabled (V 9.0.2719)

    Tools|Options|View Tab - Tick Comment Indicator Only.
    Legare Coleman

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Auditing Toolbar Disabled (V 9.0.2719)

    Bingo! Thank You!

Posting Permissions

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