How do I stop active x controls from moving after a print preview

[Guest]

Every time after going to print preview and coming back to the spreadsheet my
controls have moved to another location in the worksheet.

 

[Ken Wright]

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

Sometimes the hotfix works, sometimes it doesn't. The workaround always
does I believe.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

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

 

[Gord Dibben]

http://support.microsoft.com/default.aspx?scid=kb;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.aspx?scid=kb;en-us;832332

But others have posted that it didn't work for them in all their workbooks.


Gord Dibben Excel MVP