How do you undo macros?

Dear Giorgio

Thank you for attending Excel Advanced course. I hope you enjoyed the training.

I am not sure what you mean by undoing the macros. There is a facility to edit/modify the macros that you have recorded. It is also possible to delete the existing macros.

To modify or edit Existing Macro/s please follow these steps:

Step 1: Tools> Macro> Macros…
Step 2: Select the macro that you want to edit and then click Edit button.
Step 3: In the Visual Basic Editor Window make the relevant change.
Step 4: Press the Save button on the toolbar.
Step 5: Close the Visual Basic Window.
Step 6: When you re-run the macro the changes will be implemented.

NB: You can make simple changes such as changing the margin size, or changing the percentage, etc… To perform more complex editing you will need sound understanding of VBA. . We do offer Two days training course on VBA which might be helpful.

Please visit the following link to view more information about the course content as well as the days and venues for all the VBA Courses in the future:

http://www.microsofttraining.net/excel-london-2002-vba.php

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003

Dear Giorgio

Thank you for attending Excel Advanced course. I hope you enjoyed the training.

I am not sure what you mean by undoing the macros. There is a facility to edit/modify the macros that you have recorded. It is also possible to delete the existing macros.

To modify or edit Existing Macro/s please follow these steps:

Step 1: Tools> Macro> Macros…
Step 2: Select the macro that you want to edit and then click Edit button.
Step 3: In the Visual Basic Editor Window make the relevant change.
Step 4: Press the Save button on the toolbar.
Step 5: Close the Visual Basic Window.
Step 6: When you re-run the macro the changes will be implemented.

NB: You can make simple changes such as changing the margin size, or changing the percentage, etc… To perform more complex editing you will need sound understanding of VBA. . We do offer Two days training course on VBA which might be helpful.

Please visit the following link to view more information about the course content as well as the days and venues for all the VBA Courses in the future:

http://www.microsofttraining.net/excel-london-2002-vba.php

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003