Back up

[lisagreen]

For a simple set of VBA macros used with a workbook, I make a backup of the Excel workbook, and a Word document with the VBA Code using the Courier New font of appropriate size with the correct page size to prevent line wrap, and save it with an appropriate name.

For Excel workbooks with user forms or buttons, etc., a backup of the workbook and a Word document with the macro code with headers specifying where the code is placed.

If the macro functions are complex enough, I also create documentation in Word explaining how the macros are intended to be used along with any other requirements for the sheets, or other important information, in case someone else ever needs to use or modify the code. This is in addition to any comments in the macro code.

Thank you!!

Lisa