Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up foot page to print out the computer's name
How do I set up foot page to print out the computer's name
|
#2
|
|||
|
|||
Option Explicit
Private Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet.PageSetup .LeftFooter = "Computer name: " & Environ("Computername") End With End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- HTH RP (remove nothere from the email address if mailing direct) "Bee" wrote in message ... How do I set up foot page to print out the computer's name |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to print multiple columns on same page | Excel Discussion (Misc queries) | |||
How do I print a one page spreadsheet multiple time, each with its own page number? | Excel Discussion (Misc queries) | |||
Can I print one page landscape and the next page portrait on same. | Excel Discussion (Misc queries) | |||
My scaling is set to print 1x1 pages. But it prints 1000's of page | Excel Worksheet Functions | |||
print selected sections on the same page | Excel Discussion (Misc queries) |