When you first open the Configurator spreadsheet, you must choose enable macros.
The Macro level should be set at medium to work properly.
To set the security, open the main menu and choose Tools->Macros->Security, then select level.
Note: Low is not recommended!