set a permentant print area in a multi-sheet workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pulling/Collating Data from Workbooks 6
Eliminating Duplicate values on a large workbook 1
How to print entire workbook 9 pages to a sheet? 7
linking cells with scheduling workbook 2
changing print area in an entire workbook 7
Linking Daily Workbooks 1
Formula to sum based on a change in another column 2
Pulling rows from tabs to a "summary" sheet 8

Back
Top