Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Access Charts Linked to Files on Server [email protected] Excel Discussion (Misc queries) 0 April 3rd 07 01:54 PM
Delete ALL Charts in a WorkSheet (VB) Corey Charts and Charting in Excel 2 October 4th 06 08:41 AM
Access Charts!! Bill Charts and Charting in Excel 0 March 11th 06 11:16 AM
Import Charts and data to Access Kyriaki Charts and Charting in Excel 1 January 31st 06 07:37 PM
How Do You Delete an Excel File that Shows to "Access Denied" Riccoop Excel Discussion (Misc queries) 1 April 16th 05 12:16 AM


All times are GMT +1. The time now is 06:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"