View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default Mystery of the moving control toolbox combo box?

Oh, what I go through just to get a yellow background.

So I have these control toolbox combo boxes on some sheets. Only one per
sheet. (These are the same ones discussed in my post earlier today.) The
sheets are fully protected. But when I print, the boxes shift a ways over
to the left. Always to the same spot. If I comment out the line
ActiveSheet.PrintOut and run the code, they do not shift. On the printout
they are in their correct location. A mystery to me. Anyone have an idea
what is going on? I know if I give up on the yellow background and go back
to one on the Forms toolbar all will be fine. But do I have to?

Don <donwiss at panix.com.