| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set a permentant print area in a multi-sheet workbook
I am trying to create a bi-weekly time card in excel with the actual time
card on one tab pull info from employee information tab. I want the employee to only have one option to print no matter tab they are in. is this possible? I plan to protect the entire workbook. Thank you, Miki Merritt |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
set a permentant print area in a multi-sheet workbook
Miki
Using VBA code you can set the same print range and rows to repeat at top on each sheet in grouped sheets. For anyone interested in the code see this google search result with Dave Peterson and myself posting. The print area code is from Bob Flanagan. http://snipurl.com/106kz Gord Dibben MS Excel MVP On Fri, 5 Oct 2007 18:10:00 -0700, Miki wrote: I am trying to create a bi-weekly time card in excel with the actual time card on one tab pull info from employee information tab. I want the employee to only have one option to print no matter tab they are in. is this possible? I plan to protect the entire workbook. Thank you, Miki Merritt |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set print area for entire workbook | Excel Discussion (Misc queries) | |||
| how to set print area for the entire excel workbook | Excel Discussion (Misc queries) | |||
| Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
| Set print area on several pages at once in Excell Workbook? | Excel Discussion (Misc queries) | |||
| Print a sheet area to another... | Excel Discussion (Misc queries) | |||
Linear Mode
