Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete an embedded chart
Hi,
I am trying to delete an embedded chart from a protected sheet. But i am getting errors like "select method of chartarea class failed". Can anyone help? Here is the code: Dim ws As Worksheet Dim chObj As ChartObject Set ws = ActiveSheet For Each chObj In ActiveSheet.ChartObjects chObj.Chart.ChartArea.Select '*** error here ActiveWindow.Visible = False Selection.Delete Next chObj Thanks Gunjan Salgia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete an embedded chart
Dim ws As Worksheet
Dim chObj As ChartObject Set ws = ActiveSheet ws.unprotect For Each chObj In ActiveSheet.ChartObjects chobj.Delete Next chObj ws.protect -- Regards, Tom Ogilvy Tina wrote in message om... Hi, I am trying to delete an embedded chart from a protected sheet. But i am getting errors like "select method of chartarea class failed". Can anyone help? Here is the code: Dim ws As Worksheet Dim chObj As ChartObject Set ws = ActiveSheet For Each chObj In ActiveSheet.ChartObjects chObj.Chart.ChartArea.Select '*** error here ActiveWindow.Visible = False Selection.Delete Next chObj Thanks Gunjan Salgia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete embedded name of author/computer in excel file | Excel Discussion (Misc queries) | |||
How can I delete an embedded checkmark box? | Excel Discussion (Misc queries) | |||
Delete embedded chart, how? | Charts and Charting in Excel | |||
Delete embedded HTML | Excel Discussion (Misc queries) | |||
how do I delete thousands of pictures that are somehow embedded i. | Excel Discussion (Misc queries) |