Anne Troy
10-20-2008, 07:46 AM
With the attached workbook, on "Print", I would like Sheet2!B2 to go through each name in the range named "paynames" and print one copy of Sheet2 for each name. I would then like the workbook to save and close itself.
I would also like to be able, before distributing the workbook, to hide the sheet tabs, gridlines, and row and column headings.
Once I have this code, I'm going to try to adapt it to a few more forms, or I may add more worksheets to this workbook, that will simply print one of each normally.
Thanks in advance!!!
I would also like to be able, before distributing the workbook, to hide the sheet tabs, gridlines, and row and column headings.
Once I have this code, I'm going to try to adapt it to a few more forms, or I may add more worksheets to this workbook, that will simply print one of each normally.
Thanks in advance!!!