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

There's a free excel addin available to download here

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


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111106

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

"royUK" wrote:


There's a free excel addin available to download here

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


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111106