View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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