VBA Help - Update tool to copy Macros and Buttons from source workbook to multiple workbooks templates

[marimar02]

I would like to build an "Update" Tool that would:

• Upgrade all Workbooks in a designated folder with:
  • Macros
  • Buttons
  • Button Preferences (i.e. Color, Position, Title)

Basically, this tool should take all above items from an existing (source) Workbook and update other (destination) Workbooks in that folder.

I have automated a single workbook and would now like to copy the automation part to all the other templates.

Thanks...