Can not Print Embedded Graph on Protected Worksheet with Macro

**Henk Stander** · 09-26-2012, 11:22 AM

The worksheet is protected and the object(i.e. embedded graph) is protected. I want to print the graph with a macro but get the following error message:
"Run-time error '1004'
Activate method of ChartObject class failed."

Tried to use

Please Login or Register  to view this content.

, but still does not allow printing of the graph as per code below.

Please help.
Tnx

Please Login or Register  to view this content.

**Winon** · 09-26-2012, 12:26 PM

Hallo Henk Stander,

Goeie naand,

At the beginning of your Code as shown above enter:

Please Login or Register  to view this content.

and at the bottom of the Code:

Please Login or Register  to view this content.

Where "Sheet Name" = Actual Sheet Name, And "PassWord" = Actual Password for the Sheet.

Voorspoed.

**Henk Stander** · 09-27-2012, 02:37 AM

Goeie môre Winon,

Thank you for the speedy reply. Is there a way to do it without having to "unprotect" the sheet?

Baie dankie,
Henk

**Winon** · 09-27-2012, 03:10 AM

Goeie More Henk,

No. When you run the Macro it first UnProtects the Sheet, and after it has done printing, the Macro Protects the Sheet again.

So there is nothing to worry about.

To make it even safer you could also consider to disable the "Esc" key at the start of your code, and then re-enable it again at the end of your Code.

Probeer dit gerus!