Related Posts
Training Courses
If you want to find out more about Excel Pivot Tables or Macros then you might like to arrange an Excel training course for yourself or with some of your colleagues. It's really easy to book one of our courses and they're great value for money. See our website for full details.
Thank you very much..your guidance worked really well. Very straightforward solution. More power to you!
ReplyDeleteVery helpful and easy to follow. Thanks.
ReplyDeleteHello
ReplyDeleteVery good tutorial
Thanks a lot
What if I need a macro to run whenever a change is made, but the macro makes a change?
ReplyDeleteAlways a bit of an issue with automatic execution, how do you stop one event triggering another? The answer is to suspend event execution otherwise if you make a change in the code of the Change event then you trigger the event again and again and again....
DeleteIn your Change event enter the following statement:
Application.EnableEvents=False
That turns off event execution so that you can now safely do the things you need to do and then when you have finished reinstate it with:
Application.EnableEvents=True
Hope this helps.
Thanks a lot! after google so many source, your solution suit me the most!
ReplyDeleteIt's a good solution but a dangerous one as well, as it deactivate the possibility to undo a task. When triggered the macro is going to clear the cache to update the workbook, in result the commands CTRL-Z or CTRL-Y are deactivated.
ReplyDeletePierre, you are absolutely correct. You can not Undo a macro. When it 's done it's done.
DeleteThanks for every other informative site. The place else may just I get that kind of information written in such an ideal means? I have a venture that I’m just now operating on, and I have been on the look out for such information.
ReplyDeleteexcel vba training london