Sarah has attended:
Excel Advanced course
Macro
My understanding of Macro is that it is used for tasks done on a regular basis and once locked cannot be changed. What if one want to make amendment to the daily task, does mean that one will have to create a new macro?
RE: Macro
Hi Sarah
Thank you for your question regarding Macros
The purpose of macros is to automate repetitive tasks, due to the nature of how they are created (recording of mouse clicks/keystrokes) these exact steps will be carried out when the macro is implemented.
If any amendments to the macro are needed you would either need to create a new macro for that or if you feel confident enough to delve into the VBA (Visual Basic) coding to edit the macro, this could be another option. Understanding the visual basic element to macros would give you far more flexibility on the implementation of macros in changeable tasks.
I have included a link below for the course outline of the Excel VBA course we deliver, this would give you the understanding required to manipulate your macros in a far more efficient manner
https://www.stl-training.co.uk/excel-vba-2007.php
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post.
Kind Regards,
Nafeesa
Microsoft Office Specialist Trainer
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
