Auding Tool bar for Precedent Tracing Greyed Out

[MarieM]

How do I turn on the Precedent tracing tool bar, and when i do how do I get
rid of that little object which looks like a scrolling bar...Its grayed out,
so I went to view and turned on radio button for View all objects,,and this
allowed me to access the Precedent tracing but it also stuck a scrolling bar
on my spreadsheet. Why was it grayed out in the first place and what and how
do you get rid of htat little thingy when you click on view objects?

 

[mdupris]

One way of getting rid of the Formula Auditing Toolbar (which has
the Trace Precendents" icon) is to move the mouse into the Toolbar
area of Excel, right mouse-click, and uncheck the "Formula Auditing"
box. You can also get to it from the "Views / Toolbars" menu choice.
I'm not sure what you mean by "that little thing when you click on to
view objects" though. If it's another toolbar, or part of one, you can
enable or disable it in the same way as the Formula Auditing toolbar.
HTH

= Marchand =

 

[MarieM]

HI, I had better make my query clearer, I apolgize for not doing so. I know
about the toolbar and toggling on the check switch. My question is

1. Why would the following toolbars be GRAYED OUT on a spreadsheet with tons
of formulas.
Tools:Formula Auditing: TRACE PRECEDENTS, TRACE DEPENDENTS, TRACE ERROR,
REMOVE ALL ERRORS.

2.) When I click on Tools Options General, and under Objects click on SHOW
ALL I get a skinny vertical scrolling bar that I cannot close nor can I do
anything with it. It does blink though if I click on the bar in the middle. I
cannot move it anywhere either.

THanks for any help.
Michele

 

[mdupris]

Michele,
A couple questions:
- Is your worksheet protected (Tools / Proection)?
- What version of Excel and Windows are you using? I'm not seeing any
"Objects" or "Show all" under Tools / Options / General in Excel 2003,
for instance.


= M =

 

[MarieM]

HI, I am using Excel 2003 XP2, and when you click on Tools, Options, View, in
the middle of page it has 'Object' options. The worksheet is not protected,
the workbook is not protected.

 

[mdupris]

Marie,

Thanks for the update. I had been looking in Tools/ Options /
General. The Tools/Options/View/Object Show All command reveals all
shapes and drawing objects, on your worksheet. This leads one to think
there is a shape on your worksheet which is the scrolling bar --
possibly a remnant of object placed on the sheet long ago like a
combox box. One way to find this out is use VBA to list all shapes on
your worksheet with something like this:


Sub listObjects()
Dim i As Integer

For i = 1 To ActiveSheet.Shapes.Count
Debug.Print i & " : " & ActiveSheet.Shapes(i).Name
Next i

End sub

If you see something you don't recognize or want in that list (e.g.
"ComboBox1") You can get rid of it with the command:
ActiveSheet.Shapes("ComboBox1").delete

(I assume you've tried right-clicking on the object itself on the
worksheet and did a "Cut". If not, that's the first, easiest way to
go).

Why your Trace Precedents icon is grayed out with everything is
unprotected, I don't know.

= M =

 

[MarieM]

Thank you for your advice. I will file it away for later use. What did work
for me was if I copied and pasted the worksheet to a new sheet, all went
well. Thanks