Re: Mystery of the moving control toolbox combo box?

From: Don Wiss (donwiss_at_no_spam.com)
Date: 12/26/04 

Date: Sun, 26 Dec 2004 18:16:16 -0500

On Sun, 26 Dec 2004, Dave Peterson <ec35720@netscapeXSPAM.com> 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.aspx?scid=kb;EN-US;838910
>Controls move to the left of the work*** 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.aspx?scid=kb;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>.