View Single Post
  #1   Report Post  
cincode5
 
Posts: n/a
Default Repainting a Workbook

I have a workbook that contains about a dozen or so Rectangles that are color
formatted with fill effects. I've noticed that whenever I use a pull down
menu, a portions of the Rectangles change color. Its a subtle change of
perhaps a shade or two but its quite annoying. If I switch to another
worksheet then return the image returns back to its normal appearance.

I noticed a VBA command "Repaint", but cannot seem to figure out the correct
syntex. "HELP" say its object.Repaint, but I can't seem to get it to work
when I apply it to a Rectangle. Can someone please tell what I'm doing
wrong, or suggest an alternate method.

Thanks guys...
--
Regards...