Create add-in to print 2 pages on same page.

goofy78270

Well-known Member
Joined
May 16, 2007
Messages
555
I would like to create an add-in for MS Word that adds a new icon to the Standard toolbar that will print the active document with a 2 per page scale.

I thought about a macro, but did not want to be bothered with a warning upon open of every document nor did I want it to bother other users.

Any help on this would be great.

I tried to record my actions and came up with the code to print out the file, but I am unsure how to create this as an add-in and apply a toolbar button.
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
Hi goofy78270,

You can't do it without a macro (vba). A macro is what you get when you record your actions. And, like any other macro, is likely to generate the macro security message when the document is opened - unless, of course, you set the macro security to low ...
 
Upvote 0
Hi goofy78270,

Try this macro:
Code:
Sub TwoToPagePrint()
With Application.Dialogs(wdDialogFilePrint)
  SendKeys "{tab 4}{down 2}{tab 2}": .Show
End With
End Sub
 
Upvote 0
Thanks.

Can this not be added into an add-in? All the feeds I found on creating a word add-in require visual studio to make the add-in. Is it not possible to simply save the document as an add-in as we do in excel?
 
Upvote 0
Hi goofy78270,

If you put the macro into Word's Normal.dot template, it will load when Word starts without generating a macro warning.

To create a Word Addin containing the above macro, open a new document, insert the code into a vba module, then save the document as a Word template (dot extension).

If you want Word to load the template automatically, save it to your Word Startup folder. You can find the Word Startup folder by going to Start|Run, typing: %userprofile%\Application Data\Microsoft\Word\Startup into the dialogue box and pressing Enter.

Having saved the template, choose Tools|Templates and Add-Ins > Add, then navigate to and select the template, and click the OK button to load it as a global template.
 
Upvote 0
Thanks. I wonder if I was just looking at the wrong sites, but they all started with having to create a VS project.

By the way, once I convert the macro to an add-in, I have read that you cannot edit it. Is this truley the case? If I decide to password protect it, how do I unprotect it at a later date?

Sorry if these should be if different threads.:cool:
 
Upvote 0
Hi goofy78270,

In this case, the add-in is just a standard Word template, not a compiled program, so editing it shouldn't be a problem.
 
Upvote 0

Forum statistics

Threads
1,225,483
Messages
6,185,263
Members
453,284
Latest member
osy25

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top