I am using Charts(xxx).Protect and .Unprotect across several charts in a
worksheet. This seems to cause each chart in turn to appear in the display.
Is this a necessary eveil with protect/unprotect, or can I do it without
apparently activating each of the charts.

thanks.

Have you tried toggling the screen updating

Applicaiton.screenUpdating = false
'Your Code here
Application.screenupdating = true
--
HTH...

Jim Thomlinson


"timp" wrote:

I am using Charts(xxx).Protect and .Unprotect across several charts in a
worksheet. This seems to cause each chart in turn to appear in the display.
Is this a necessary eveil with protect/unprotect, or can I do it without
apparently activating each of the charts.

thanks.

thank you yes... I think I was reluctant because I thought it shouldn't NEED
toggling - but after a cup of coffee I saw sense and just did it

"Jim Thomlinson" wrote:

Have you tried toggling the screen updating

Applicaiton.screenUpdating = false
'Your Code here
Application.screenupdating = true
--
HTH...

Jim Thomlinson


"timp" wrote:

I am using Charts(xxx).Protect and .Unprotect across several charts in a
worksheet. This seems to cause each chart in turn to appear in the display.
Is this a necessary eveil with protect/unprotect, or can I do it without
apparently activating each of the charts.

thanks.

Hi Jim,

Thanks for this code - I'm going to use it a lot more in the future. I often
write macros that use the autofilter functions - the screen flickers a lot
using them. But not any more!

Thanks again
Peter

"Jim Thomlinson" wrote:

Have you tried toggling the screen updating

Applicaiton.screenUpdating = false
'Your Code here
Application.screenupdating = true
--
HTH...

Jim Thomlinson


"timp" wrote:

I am using Charts(xxx).Protect and .Unprotect across several charts in a
worksheet. This seems to cause each chart in turn to appear in the display.
Is this a necessary eveil with protect/unprotect, or can I do it without
apparently activating each of the charts.

thanks.