To implement the solution, please execute the following steps:
1. For Excel users:
a. Click File -> Options.
b. Click 'Trust Center' link in the 'Excel Options' window.
c. Click 'Trust Center Settings...' button.
d. In the 'Trust Center' window click 'Macro Settings' link from the menu on the left.
e. Under 'Macro Settings' check 'Disable all macros with notification'.
f. Under 'Developer Macro Settings' check 'Trust Access to the VBA project object model'.
g. Click 'OK' button to close the 'Trust Center' window.
h. Click 'OK' button to return to the spreadsheet.
2. Retest the issue.