Combine similar macros into one

why did you attach doc file ? xlsm file would be more useful for testing

Hi, ATOP,

maybe reduce the code to just one event which is to be inserted into ThisWorkbook and will get fired every time the workbook is printed or the pagepreview is elected:

Please Login or Register  to view this content.

@patel45:
no answer certainly would have been a much better answer - if you canīt help I request that you simply do not post.

Ciao,
Holger

Originally Posted by HaHoBe

if you canīt help I request that you simply do not post.

you can request what you want, you are forgetting i'm collecting sample workbooks
Please avoid comment on my answers

Patel,

There is nothing wrong with providing the code in a word doc. Its not mandatory that it should be provided in a .xlsm file only.

I never said it was wrong, I said xls file would be more useful

Ok.

Holger, Patel also has his viewpoint. He possibly doesnt want to go thru the extra step of moving the code from the word doc to the excel file and prefers directly testing it on the excel file. Its his viewpoint and lets respect it.

So its best you both continue the good work of helping others and not worry about what the other is saying. If one of you is comfortable with the excel file, use it and if you are comfortable with word, continue. Arguing with each other will not help the forum or the OP.

Hi, Arlette,

I appreciate your efforts to calm things down.

But I wonīt pass

you can request what you want, you are forgetting i'm collecting sample workbooks

Is this a help forum or a chat? Users tend to look at the number of posts by a member and judge the "quality" of any answer even from that, so any posting of whatever quality will be helpful for that kind of "reputation". Does any of patel45īs posts in this thread help the TO to solve the problem? I really appreciate your answer on that - speaking for myself: if I canīt answer a question put in any forum I pass that - maybe some other user has a better understanding of the problem or can imagine a solution to that. Thatīs my point - patel45īs POV is in the quote?

I know how difficult it is to be of any help to users (believe it or not - Iīve even gone through the moderating stuff on a forum for more than a decade by now) and I wonīt buy that - that all (no, no excuse on foreign languages accepted here - english is definitely not my native tongue but I can at least try to improve my skills on it, thatīs one of the reasons an old dog like me has taken a more active part since August of last year than in the first seven years of my membership with this forum).

And personally I like best

Please avoid comment on my answers

For Each ... Step 2 patel45 has spoken - please, no comments on the Step 2.

Ciao,
Holger

Ok, maybe we 3 can take this offline, instead of bombarding this OP's thread. Let the guy not get confused and get the solution he needs.

The chat was started from HaHoBe with

@patel45:
no answer certainly would have been a much better answer - if you canīt help I request that you simply do not post.

this does not help TO to solve the problem.
HaHoBe likes my claim to avoid comment on my answers ?
I hope he will do it, I will report all his comments to my answers

Hi, ATOP,

the code for the buttons as well as the code for printing all sheets in Module3 looks like this:

Please Login or Register  to view this content.

Two global variables are used to hold the name of the Sheet and the Range respectively. In ThisWorkbook the code looks like this:

Please Login or Register  to view this content.

Ciao,
Holger

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.