Conform to Company Guidelines and Standards – Macros that don’t adhere to, or even deliberately flaunt, company standards and guidelines are doomed to failure. Before you start on a new macro ensure that you know the companies standards for macro development.
Document Macros – It is highly likely that in a week or two you will have forgotten what exactly your macro does or even the next person to do your jobs come’s a long and has no idea of the complex operations of your macro. You could help them yourself and those out by writing in comment lines in the macro code which explain what is happening and how you have created it. All macro languages can be commented on without ruining the code for the macro.
Print a Copy of the Code – in Microsoft Excel you can print your macros from the VBA editor this is good for cheeking the macro and for using as an archiving document.
Train Other Users – Train other users to be able to use macros correctly, if you cannot train someone then produce a set of instructions for them to follow and they can teach themselves.