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

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