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 =

On Feb 9, 12:50 pm, MarieM wrote:
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?