Excel XP: Why do my controls move to left side of sheet when I do.

[Guest]

I have placed controls (text boxes, command buttons, etc.) and set the
placement on all of them to Freefloating ("Do Not Move or Resize with
Cells"). When I perform a Print (or Print Preview), all the controls are
moved to the far left side of the worksheet. This does not happen when I set
the placement of the controls to
MoveAndResize.

 

[Jim Rech]

This was fixed in the 10/12/2004 Security Update which you should be able to
get at Office Update.

--
Jim Rech
Excel MVP
|I have placed controls (text boxes, command buttons, etc.) and set the
| placement on all of them to Freefloating ("Do Not Move or Resize with
| Cells"). When I perform a Print (or Print Preview), all the controls are
| moved to the far left side of the worksheet. This does not happen when I
set
| the placement of the controls to
| MoveAndResize.

 

[Gord Dibben]

Phil

Cause and a hotfix supplied here.....

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910

Gord Dibben Excel MVP

On Thu, 11 Nov 2004 11:23:02 -0800, "Phil Burlison" <Phil

 

[Jim Rech]

This article is now obsolete, Gord. 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

 

[Gord Dibben]

Thanks Jim

Will file this away.

Gord

 

[Myrna Larson]

Hi, Jim:

I downloaded the security patch and installed it.

I had two workbooks that exhibited this moving button problem; I had
previously fixed it by changing the placement to 1 (move and size with
cells) as noted in the original KB article.

After applying the patch, I changed the placement settings to 2 (move but
don't size with cells). One of the workbooks now behaves properly, the
otherone doesn't!

I guess it's back to the drawing board at MS on this one.

Myrna Larson