Do I have to create a macro for print?

[foxcole]

I'm a little surprised there don't seem to be any help topics or discussion
threads on this. Also please bear with me; I haven't worked with custom
buttons since Excel 97 and am not even sure how much I remember from that.

What I want to do is create a button on each worksheet in a workbook that
runs the Print command, specifically setting options to print the current
worksheet only, and to fit to page; some will need landscape orientation. Do
I have to create a macro for this, or can I somehow get it to run the Print
dialog with these options selected? (I can't find any information on running
commands from a custom button, only on assigning and running macros.)

If a macro is necessary, is this a recordable sort? This workbook will be
used by service technicians in the field so would have to use whatever
printer is available, with the above specifications... so I wouldn't want the
printer selection to be recorded, only the settings.

(I need "fit to page" because the minimum printer margins can vary by
printer device, and the creator of the Excel workbook took great pains to fit
each to 0.2toto" left and right margins. This workbook is a set of forms,
with very touchy layouts. I've tried adjusting columns but it seems a much
better idea and quicker solution to just have each form fit to the page.)

Any advice or help would be greatly appreciated.

Cheers!
--
FoxCole

"Drawing on my fine command of the English language, I said nothing."

Robert Benchley (about his response to someone who said at a dinner party,
"Say something funny, Mr. Benchley.")

 

[foxcole]

Whoops -- forgot to mention I'm using Excel 2003.

--
FoxCole

"Drawing on my fine command of the English language, I said nothing."

Robert Benchley (about his response to someone who said at a dinner party,
"Say something funny, Mr. Benchley.")

 

[Gord Dibben]

What's more surprising to me is that a google search did not turn up a
gazillion items on "print macro"

But................you will have to record a macro for each sheet's print
settings and assign a button on each sheet to the appropriate sheet macro.

Edit the macros to eliminate any specific printer selection.


Gord Dibben MS Excel MVP

 

[foxcole]

Hello, Gord! Wow... thank you for the lightning-fast reply.

What's more surprising to me is that a google search did not turn up a
gazillion items on "print macro"

Except that I wasn't sure I had to use a macro...

But................you will have to record a macro for each sheet's print
settings and assign a button on each sheet to the appropriate sheet macro.

Edit the macros to eliminate any specific printer selection.

Thanks! That's very helpful... and still easier than trying to reformat
those forms.

Cheers!
--
FoxCole

"Drawing on my fine command of the English language, I said nothing."

Robert Benchley (about his response to someone who said at a dinner party,
"Say something funny, Mr. Benchley.")