G
Guest
How do I delete a chart that will not allow me to click on it?
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.
J
Jon Peltier
If the sheet has been protected, you need to unprotect it first (Tools menu).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
G
Guest
It's not protected.
Jon Peltier said:If the sheet has been protected, you need to unprotect it first (Tools menu).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
J
Jon Peltier
Is it an embedded chart object?
Where did you get it from?
Select the chart, press ALT+F11 to open the VB Editor. Press CTRL+G to open the
Immediate Window. Enter this line and press Enter:
?activechart.ProtectSelection
it will return False if it isn't protected.
Enter this line and press Enter:
?activesheet.protectcontents
it will return False if it isn't protected.
If this doesn't clarify things, post back.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Where did you get it from?
Select the chart, press ALT+F11 to open the VB Editor. Press CTRL+G to open the
Immediate Window. Enter this line and press Enter:
?activechart.ProtectSelection
it will return False if it isn't protected.
Enter this line and press Enter:
?activesheet.protectcontents
it will return False if it isn't protected.
If this doesn't clarify things, post back.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______