
If you weren't asked about enabling macros when you opened the workbook, it could be because of the security level you have set on Excel itself.

If you don't enable them, then the security setting on the workbook is set to a high enough level that the macros (and doing anything with the macros) are disabled. For instance, when you first open the workbook, you may be notified that it contains macros and asked if you want to enable them. There are any number of reasons why the options would not be available, but they all boil down to security settings for the workbook. She wonders why they are disabled and how she can make them available.

Micky noted that when she opens a particular workbook in Excel and displays the Developer tab on the ribbon, some of the tools are disabled (Macros, Visual Basic Editor, Record Macro).
