Since it is your macro, just change it so it does not show the confirmation msgbox.
Since it is your macro, just change it so it does not show the confirmation msgbox. When you need the macro in another context where the confirmation msgbox shall appear, add a boolean flag useConfirmationMsgBox as Boolean to your macro code, and show the MsgBox only when this flag is true. Then, provide two different entry points, one where useConfirmationMsgBox is set to true, and one where it is set to false.
Thanks for the reply Doc Brown. I want to do this without editing macro code as it will affect lots of documents in our company... if I update the template, it will be really overhead:(... – AnarchistGeek Mar 1 at 14:36 If I got you right, you are not running one macro, but a dozens (or more? ) of copies of the same macro?
Your macro is not part of a document template which could be changed in a single place? Well, that will give you a maintenance nightmare fewer or later. In fact, it may be possible to send a simulated "Enter" key stroke using the Windows messaging system to the confirmation MsgBox, but these kinds of solutions tend to be very unstable, and I would not recommend that seriously.
Better try to separate you macros from your documents. – Doc Brown Mar 1 at 15:22.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.