Delete a sheet and access charts
It is possible you have more than one worksheet selected.
Do you see [group] behind the filename in the titlebar?
If so, you have grouped two or more sheets.
Right-click and "ungroup".
Note: while sheets are grouped, what is done to one will be done to all, so
carefully check to see what changes have been made.
Gord Dibben MS Excel MVP
On Thu, 5 Apr 2007 16:12:00 -0700, Jim--Kent
wrote:
I have a workbook with several pages of data. I have a sheet named Reports
that has several charts that display the data from other sheets. This week
the entire page of charts cannot be editted, the drawing toolbar icons are
dithered out and cannot be used, the protection menues are dithered out and
the sheet or workbook has not been protected, and the sheet itself cannot be
deleted as that menu is also dithered out.
I'm stumped as to what happened
|