Home |
Search |
Today's Posts |
#1
|
|||
|
|||
printing on excel
Hi All,
Does anyone know how i can place a page number or counter formula on a spreadsheet that will automatically update everytime i print a copy out. Essentially i want to count how many times i have printed the one spreadsheet over a period of time. i.e - the counter or page number will be 10 if i have printed 10 copies of the spreadsheet or printed the sheet ten times. Please give some guidance if anyone has done this before. Thanks, James |
#2
|
|||
|
|||
Give yourself a macro to run.
Option Explicit Sub testme() With Worksheets("sheet1") With .Range("a1") If IsNumeric(.Value) Then .Value = .Value + 1 .Parent.PrintOut preview:=True Else MsgBox "Cell isn't numeric!" End If End With End With End Sub Remember to save the workbook or the counter will go back to what it was when you opened the workbook. I used A1 of Sheet1 and preview:=true (to save trees). Modify to match your needs. James Westh wrote: Hi All, Does anyone know how i can place a page number or counter formula on a spreadsheet that will automatically update everytime i print a copy out. Essentially i want to count how many times i have printed the one spreadsheet over a period of time. i.e - the counter or page number will be 10 if i have printed 10 copies of the spreadsheet or printed the sheet ten times. Please give some guidance if anyone has done this before. Thanks, James -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Problems printing templates in Excel XP | Excel Discussion (Misc queries) | |||
Printing - different machines, same excel, printer and driver | Excel Discussion (Misc queries) | |||
How to prevent user from printing in Excel? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |