New Macro I created to format a page and print, prints 5 copies

I created a new macro to format a page to US Letter and print 1 page wide and 1 page tall, then print. All works fine, but it prints 5 copies. I have made two different named macros and they both do the same thing. Help?!

I am not sure what you mean by "my code".... I used mouse clicks to record the macros... ?

OK, well.... I started by clicking on Tools, then the drop down to Macros, then Record new Macro. From there, I named my Macro, then in the box for the shortcut key, I put an "p" and clicked OK.

I immediately went to File > Print > Page setup > Options > changed the paper size to Letter > OK > clicked "Fit to 1 page wide by 1 page tall > Print.

Then I went back to Tools > Stop Recording Macro.

When I press Option + Command + p, it does it's thing and prints 5 copies.

Is that what you wanted to know?

In order to solve your problem. We need code.

Press ALT+F11 --> click module -----you can see some codes ----copy that codes ----- post to this thread

@ tamalloni

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

@Thameem127
Thank you, I tried this and now it prints only two copies.

@Cutter
OK, Sorry, I am new to this forum and was not aware. I will do that in the future. Thank you.

Originally Posted by tamalloni

@Thameem127
Thank you, I tried this and now it prints only two copies.

Hai tamalloni,

If your satisfied with my code. Please mark this thread as solved.

@ Thameem127, I am new to this site, can you tell me how to mark is as solved?

Originally Posted by tamalloni

@ Thameem127, I am new to this site, can you tell me how to mark is as solved?

Go to Thread Tools available in the top left of this thread ----> click it----> select Mark this thread as solved.

@ tamalloni

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

The reason I never marked it as solved was because "Winon" had asked me to post the code that was printing two copies, which I did, and I assumed he/she would have replied with another solution. Ultimately, I only want one page to print, not two. So technically it is not solved. But it's ok. Thank you all for your help.

Winon, were you going to suggest a new code?

Please Login or Register  to view this content.

I think it should print twice as you instructed it to do so.
Delete the 2nd of the above lines and it should just print one page.

Also, search for "cleaning code generated by macro recorder"
You can shorten the code considerably and the bonus will be that you'll learn about coding.