ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Cannot select charts in Spreadsheet (https://www.excelbanter.com/charts-charting-excel/164173-cannot-select-charts-spreadsheet.html)

CH

Cannot select charts in Spreadsheet
 
Hello !

I received a spread sheet which the originator must have made some setting
to prevent the selection of the charts in the spread sheet.

I also notice the drawing toolbar has been masked (buttons are dull colored
cannot be selected).

What can I do to change this setting on selection of the charts so that I
can edit them ?

Thanks in advance.

Barb Reinhardt

Cannot select charts in Spreadsheet
 
Is the workbook/worksheet protected?
--
HTH,
Barb Reinhardt



"ch" wrote:

Hello !

I received a spread sheet which the originator must have made some setting
to prevent the selection of the charts in the spread sheet.

I also notice the drawing toolbar has been masked (buttons are dull colored
cannot be selected).

What can I do to change this setting on selection of the charts so that I
can edit them ?

Thanks in advance.


CH

Cannot select charts in Spreadsheet
 
It is not protected through the Tools Options selection.

"Barb Reinhardt" wrote:

Is the workbook/worksheet protected?
--
HTH,
Barb Reinhardt



"ch" wrote:

Hello !

I received a spread sheet which the originator must have made some setting
to prevent the selection of the charts in the spread sheet.

I also notice the drawing toolbar has been masked (buttons are dull colored
cannot be selected).

What can I do to change this setting on selection of the charts so that I
can edit them ?

Thanks in advance.


Barb Reinhardt

Cannot select charts in Spreadsheet
 
Might the workbook be shared?
--
HTH,
Barb Reinhardt



"ch" wrote:

It is not protected through the Tools Options selection.

"Barb Reinhardt" wrote:

Is the workbook/worksheet protected?
--
HTH,
Barb Reinhardt



"ch" wrote:

Hello !

I received a spread sheet which the originator must have made some setting
to prevent the selection of the charts in the spread sheet.

I also notice the drawing toolbar has been masked (buttons are dull colored
cannot be selected).

What can I do to change this setting on selection of the charts so that I
can edit them ?

Thanks in advance.



All times are GMT +1. The time now is 02:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com