View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Mystery of the moving control toolbox combo box?

xl2002???

http://support.microsoft.com/default...b;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002

But Jim Rech recently posted this:
This article is now obsolete. Since the 10/12/2004 security patch
there is no need to get a hotfix (although this article does not directly
mention this fix, it's in there).

http://support.microsoft.com/default...b;en-us;832332

But Myrna Larson posted that it didn't work for her in all her workbooks.

Don Wiss wrote:

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.


--

Dave Peterson