S
Stephen W. Hiemstra
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
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