View Single Post
  #3   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?

On Sun, 26 Dec 2004, Dave Peterson wrote:

Don Wiss wrote:
... I have these control toolbox combo boxes on some sheets.
... when I print, the boxes shift a ways over to the left.


xl2002???


Yes.

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


It says to switch to Move and size with cells. I can do that. I need move
with cells, but which ever size is set to shouldn't matter. That fixed the
problem.

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.


I have automatic Windows updates, but I gather that is only for the OS. I
will get this now... Nope. It says my Office products need no updates. I do
now remember that I updated Office in the past month or so. So like Myrna
it didn't work for me.

And then this application is for work, and I don't know whether they have
this update. But the switch to Move and size with cells is fine.

Thanks. I spent a good while trying to pin down the cause of this mystery.

Don <donwiss at panix.com.