Print Menu

[Tami]

i have a large document that i print out almost daily. Everyone goes in and
prints the pages they are interested in. most people want the two sumary
pages and then like to print their own dept pages. can i give them an easy
print menu so that they don't have to go in and edit the print from/to ranges?
thanks so much,
tami

 

[royUK]

There's a free excel addin available to download here

'SheetsToPrint'
(http://www.4shared.com/file/92296694/6ebb1733/SheetsToPrint.html)

 

[Tami]

that's pretty cool...but i actually need the usere to choose range names, not
sheets as the document is really long...any suggestions