Macro to set print area
 

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!

Macro to set print area
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Toydude5150" wrote in message
...
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!