Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print signature lines as footer
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you get the footer to print in Excel? | Excel Discussion (Misc queries) | |||
inserting Long Text Lines in Footer | Excel Discussion (Misc queries) | |||
My header and footer show in print preview but don't print. | Excel Discussion (Misc queries) | |||
I need my footer to print with 7 different names. | Excel Discussion (Misc queries) | |||
Print Footer with Last Print Date field name | Excel Discussion (Misc queries) |