Controls Moving After Print Preview 2

[Sheffield]

Greetings,

I'm using Excel 2003 and have placed several Checkboxes and a single Button on a Worksheet. Everything works perfectly with one glaring exception: the Controls (Checkboxes and Button) are being progressively repositioned to the left, with each subsequent 'print preview', until their Left properties equal 1.5.

Can anyone make sense of this?

During the 'Print Preview', the screen appears to displaying the data correctly. However, the problems occur immediately after Excel exits the 'Print Preview'.

I have stripped 100% of the VBA code from the Worksheet, but the problem persists.

I would greatly appreciate any help anyone can provide. This is killing me.

Thanks

 

[GVF]

Right click on an object (you can hold down the shift key and select multiple objects). Right click on the object. Select "Format Control". On the properties tab, select "Do not move or size with cells".

That should do it.

 

[KenWright]

Here's why:-

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

The fix doesn't always work, but the workaround does.

Regards
Ken...............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[HughLerwill]

GVF,

Thanks and a star for you mate!

regards Hugh