I get an error “Cannot run the macro…” ??

It sounds like you have macro’s disabled. Follow these steps in Excel:

  1. Click the File tab.
  2. Click Options.
  3. Click Trust Center, and then click Trust Center Settings.
  4. In the Trust Center, click Macro Settings.
  5. Make the selections that you want.
  6. Click OK.