Will you always be printing the same range of data?
Record a Macro of the operation you want to complete e.g. highlight area you
want to print and then hit the print button.
The go to <View><Toolbars><Forms> and click on the button symbol and place a
button on your worksheet. [You can size the button to whatever size]. Then
right click the buttonand select <Assign Macro>. Select the macro you just
recorded.
Now when you press the button it will execute the command to select the area
you specified earlier and print it.
This is ought to be straight forward. If you have problems do write back and
I can assist you further.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
