jaylyncokem
New Member
- Joined
- May 10, 2012
- Messages
- 1
Hi all! I have looked through a tun of threads about print macros, but none of them are quite what I'm looking for.
First of all, I am using Excel 2010. I have a workbook that has roughly 150 worksheets in it with information for each of my employees. I am looking to set up a macro that will only print a designated page on each of the non-hidden worksheets. Each worksheet has a print area set up with 2 pages of information (pg 1 of the sheet is their "Report Card" and pg 2 of the sheet is their ID badge). I would like to be able to press a button and print only the Report Cards (on non-hidden worksheets) for all employees. And then I would like to press another button to print all the ID badges (again on non-hidden worksheets).
Any help would be greatly appreciated!!
Thanks!
~Jaylyn
First of all, I am using Excel 2010. I have a workbook that has roughly 150 worksheets in it with information for each of my employees. I am looking to set up a macro that will only print a designated page on each of the non-hidden worksheets. Each worksheet has a print area set up with 2 pages of information (pg 1 of the sheet is their "Report Card" and pg 2 of the sheet is their ID badge). I would like to be able to press a button and print only the Report Cards (on non-hidden worksheets) for all employees. And then I would like to press another button to print all the ID badges (again on non-hidden worksheets).
Any help would be greatly appreciated!!
Thanks!
~Jaylyn
