Do I have to create a macro for print?
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.") |
Do I have to create a macro for print?
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.") "foxcole" wrote: 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.") |
Do I have to create a macro for print?
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 On Mon, 16 Mar 2009 09:15:02 -0700, foxcole wrote: 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! |
Do I have to create a macro for print?
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.") |
All times are GMT +1. The time now is 12:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com