protect/unprotect & display flicker

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select an embedded Chart within a Protected Sheet 2
Protection Error 4
Copying in sheet with protection with the use of a macro 5
Protecting worksheet. 1
How do you Determine if a Worksheet is protected? 2
Unprotect Workbook with Function 3
best way protect unprotected cells 2
How to bypass password when pasting FROM a protected workbook 3

Back
Top