You sure you're not using xl2002???
http://support.microsoft.com/default...b;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...b;en-us;832332
"Stephen W. Hiemstra" wrote:
I have an Excel 2000 worksheet where I have added a number of controls
and user-defined VBA functions and sub routines. I added a subroutine
Public Sub Workbook_BeforePrint(cancel As Boolean)
End Sub
to print footers when printing. However, after I look at print
preview, several of my controls migrate to new locations in my
worksheet. Printing reveals that the new locations get printed.
Because not all of my controls get moved around, I am wondering if I
did something to set off this behavior and, in any case, if there is a
fix.
Can someone lend me a hand?
Stephen
--
Dave Peterson