Macro to set print area

T

Toydude5150

Hi,

Can one of you Excel Gurus help me?

I would like to basically put a button on a spreadsheet that runs the macro
that is attached to the "Set Print Area" button in the standard menu.

I want my user to be able to highlight the selection to be printed, then
click the button so that the selection is set as the print area. Is this
possible?

Any help would be great!

Thanks!
 
J

Jon Peltier

Why not add the Set Print Area button to an existing toolbar?

Tools menu > Customize > Commands tab. Select File in left list, scroll
halfway down right list, drag Set Print Area button to a convenient place.

You could add this programmatically as well.

- Jon
 
Top