B
Billy
i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso
auditing tools are unusable [faded out]. why?
Tonso
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Billy
i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso
Also, the drawing tools are not hightlighted either.
Tonso
G
Gord Dibben
What do you consider as a "spreadsheet"?
A workbook or a worksheet within a workbook?
Sounds to me like your worksheet is protected under Tools>Protection>Protect
Sheet.
Gord Dibben MS Excel MVP
A workbook or a worksheet within a workbook?
Sounds to me like your worksheet is protected under Tools>Protection>Protect
Sheet.
Gord Dibben MS Excel MVP
i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso
Also, the drawing tools are not hightlighted either.
Tonso
B
Billy
What do you consider as a "spreadsheet"?
A workbook or a worksheet within a workbook?
Sounds to me like your worksheet is protected under Tools>Protection>Protect
Sheet.
Gord Dibben MS Excel MVP
i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
TonsoAlso, the drawing tools are not hightlighted either.
Tonso- Hide quoted text -
- Show quoted text -
Gord,
I meant worksheet. To be exact, the workbook in question has 6
worksheets, none of which are protected. On every sheet, the auditing
tools (trace precedents, trace dependents), along with drawing tools
(cirlces, rectangle, lines, etc.) cannot be accessed. Cells can be
merged, formatted, borders added, but no trace precedents/trace
dependents, which is what I want to do. I tried protecting and then
unprotecting the worksheets.
Tonso
G
Gord Dibben
Without protecting a sheet, I can't find a way to replicate your problem in
version 2003.
Something both of us are missing......hopefully we will get some more
suggestions from the group.
Gord
version 2003.
Something both of us are missing......hopefully we will get some more
suggestions from the group.
Gord
S
sysmod
Try
View > Toolbars > Customize... > Reset
No drawing objects or multiple tabs selected?
Try Copy all to a new sheet
Check out
http://www.mvps.org/dmcritchie/excel/grayedout.htm
http://www.mvps.org/dmcritchie/excel/toolbars.htm
HTH
Patrick
View > Toolbars > Customize... > Reset
No drawing objects or multiple tabs selected?
Try Copy all to a new sheet
Check out
http://www.mvps.org/dmcritchie/excel/grayedout.htm
http://www.mvps.org/dmcritchie/excel/toolbars.htm
HTH
Patrick
B
Barbara Wiseman
Tonso,
Could it be that you have several sheets selected, after the workbook name
at the top of the excel window does it have [group]. If so right click on
one of the sheet tabs and click on ungroup sheets.
Barbara.
Could it be that you have several sheets selected, after the workbook name
at the top of the excel window does it have [group]. If so right click on
one of the sheet tabs and click on ungroup sheets.
Barbara.
T
Tonso
Tonso,
Could it be that you have several sheets selected, after the workbook name
at the top of the excel window does it have [group]. If so right click on
one of the sheet tabs and click on ungroup sheets.
Barbara.
i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso- Hide quoted text -
- Show quoted text -
No, there are no grouped sheets.
Tonso
T
Tonso
Tonso,
Could it be that you have several sheets selected, after the workbook name
at the top of the excel window does it have [group]. If so right click on
one of the sheet tabs and click on ungroup sheets.
Barbara.
i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso- Hide quoted text -
- Show quoted text -
There are several workbooks that are linked to this workbook.
Tonso