The trick is, when you record the macro, in the Store macro in field, you should select Personal Macro Workbook. You record a macro by turning on the Developers tab —go to File tab, select Options, ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback