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.


" wrote:

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 =


On Feb 9, 2:15 pm, MarieM wrote:
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

" wrote:
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 ofExcel, 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?