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