Hyperlink For Printing

Hello

I have a worksheet that can be up to 100 pages in length. At the end of each week I must print the sheet for that week. I would like to put a hyperlink beside each page (just out of the print area) that will print just that page. I know i can use the FILE>PRINT>PAGE> # : # method, but i was hoping that some of you Excel Gurus would know a way to just click one link and just that page would print.

Thanks in advance for any help i can recieve on this subject

[email protected]

Thanks Dave

but that isnt quite what i was looking for. i need something that is user friendly. if the user has to click then choose items on a menu he might as well click file>print and then choose his pages. what i was hoping for is a command that will print just the page that the link is assigned to.

thanks
[email protected]

just hoping someone would have an idea

Ok, what i have done so far is ive recorded a macro where i highlighted page 1 then clicked file>print>selection

then i inserted a command button that will run this macro. this works good and accomplishes what i need it to do, except that it is only gonna work with page one. this spreadsheet can be up to 100 pages long and i dont want to have to record a different macro for every new page. is there anyway i can copy and paste this macro on down the sheet and have the highlighted cell range move with the pasting? i know that when i enter my formulas they will progress down the sheet, but i am new to the macro game, any help would be appreciated.

[email protected]

Dave you are a good help, but like i said earlier. Im new to the Macro game. But i am pretty sure i dont see any code BELOW your last post.

[email protected]