Strange PrintOut Behavior

[Bob Nonnemann]

I have a simple timesheet application with some buttons
the clear rows, insert rows, etc. that all work fine. I
added another button to print the timesheet:

Private Sub cmdPrint_Click()
ActiveSheet.PrintOut
End Sub

Which prints the sheet; however after printing most of
the buttons on the sheet have 'moved' way over to the
left side of the spreadsheet! This problem only occurs
with Excel 2002, it works fine with Excel 2000.

Any suggestions?

 

[Ron de Bruin]

Maybe this is your problem Bob

http://support.microsoft.com/default.aspx?scid=kb;EN-US;838910
Controls move to the left of the worksheet in Microsoft Excel 2002