Hi ng
Using xl 2003

Using nodupes to print employee timesheets
(An individual sheet prints for each employee based on name in col A)

Would like to also print signature lines at bottom of each report

Tried this,not working

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Application.ScreenUpdating = False
Sheets("mytools").Select
Set myfooter = Range("A11:F16")

ActiveSheet.PageSetup.RightFooter = myfooter

End Sub

The data to be printed is on Time_Entry!

The footer should have line for employee signature and another line fo
mgr signatur

--
Message posted from http://www.ExcelForum.com