Printing Macro- Need to auto apply to all open Excel documents

**cupcakes** · 01-21-2013, 04:35 PM

My apologies if this thread has already been posted/solved. I'm very new to Macros. I'm using one from this forum to set printing preferences to "fit all columns one page" under portrait orientation. It works like a charm, but only for one doc at a time. Is there something I should add to below code to get it to apply to all open workbooks? I want it to apply these preferences to a number of open documents, not just the one I applied the Macro. Please let me know if you need any more information.
I'm using Excel 2010 on Win 7
Thanks!

Please Login or Register  to view this content.

**mrice** · 01-21-2013, 04:40 PM

Try this

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.

**xladept** · 01-21-2013, 04:46 PM

Hi cupcakes,

Try this:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code into the white space on the right

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name