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
 

Ask a Question

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.

Ask a Question

Similar Threads

Setting print area 3
Macro to control Print area/view 2
Macro for Print Area 1
VBA to set dynamic print area 1
Find print area when no print area set 3
Set Print Area with Dynamic Start Point 2
Set Print Area 3
Setting Print Area 5

Top