Msbox for runing or not runing a macro.

[apla]

Hi VBA Experts!

I use this code for coping and paste special in another sheet some ranges and also to print a speciffic area.

Please Login or Register  to view this content.

I'd like to add a new Msbox before the print Msbox(Bolding with red letters, in the above code), that will say

"Are you sure"

If the answer is yes, then proceed to the next step.

If the answer is NO, then no procced and do nothing waiting for yes confirmation!

Thanks in advance for any suggestion.

[stnkynts]

Maybe:

Please Login or Register  to view this content.

[apla]

Thank you for your reply!

Is any line in the code(that obviously i don't see-forgive me for this-) that add a new Msbox?

Because i don't see this and of course the code gives me the same results as before. No new Msbox at all!

[Winon]

Hello apla,

What stnkynts had given you, does indeed present you with a second message box, provided that you reply yes with the first message box.

[apla]

That's why you are a Guru. Thank you. This is good and i'll keep it in my code but i asked for something different!

..I'd like to add a new Msbox before the print Msbox(Bolding with red letters, in the above code), that will say

"Are you sure"

If the answer is yes, then proceed to the next step.

If the answer is NO, then no procced and do nothing waiting for yes confirmation!

In simple words i want to ask the user if is sure that wants to run the whole macro(copying-pasting to the other sheet)

If choose yes then the next step is the Msbox asking for printing etc.... If the answer is NO, then the whole macro will not run.

Can you help on this pls?

[stnkynts]

Please Login or Register  to view this content.

[apla]

So simple when you know how to do this!

Thank you very much!