Creating a Microsoft Excel Add-in

  To create a Microsoft Excel add-in file:

  1. In the VBA editor, select Tools, then Properties.

  2. Select the Protection tab.

  3. Select Lock Project For Viewing.

  4. Enter the appropriate password.

  5. Click OK.

  6. In Microsoft Excel, select File, then Save As.

  7. In Save As Type, select Excel Add-In (*.xla), the last item.

  8. Enter the name to use for the add-in.

  9. Click Save.