Strange PrintOut Behavior
 

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?

Strange PrintOut Behavior
 

Maybe this is your problem Bob

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bob Nonnemann" wrote in message ...

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?