1) Right click on the unused part of your toolbar at the top of your
spreadsheet
and select Forms.
2 ) You will now see a Forms toolbar.
3) Click on the Button icon. (rectangular grey box).
4) Your mouse cursor on your spreadsheet will now turn to a cross.
5) Hold your mouse button down and drag it to form the button to the
size you want & then release.
6) When you release an 'Assign Macro' window will be displayed.
7) Click on 'New'.
This will take you to the Properties window where you will see two
commands already there.
They will be a Sub Button header which will be the name it has called
the macro button you have just generated, and an End Sub command.
Your print macro needs to be imbedded between these two commands.
If you leave off the 1st and last line of the program I sent you and
paste the rest between your two commands.
Your program should now begin with a Sub Button () looking command and
end with an End Sub.

What you need to do now is tailor my program to hide the cell range
that you dont want to print, and enter the cell range that you do want
to print.


--
grahammal
------------------------------------------------------------------------
grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
View this thread: http://www.excelforum.com/showthread...hreadid=541549