Auto Flash Similar to the above – this function will be greyed out unless you're in iAuto(+), or the Portrait and Macro Scene modes. Found inside – I probably should mention, though, that this option will be greyed out if you're in P/A/S/M modes. It may not display this or other websites correctly. This updated edition of Excel 2007 Miracles Made Easy features the amazing new upgrades offered in Excel 2010 and prepares users to transition to it. I have excel 2007 and I want to record a macro. 09:51 AM How to fix grayed out options in Settings. A guide to PowerPivot and Power Query no data cruncher should be without! Choose the desired macro security setting, then click the OK button. Macros do not run and unable to record new macros as 'Record Macro' is greyed out. Scroll down to the “Display options for this workbook:”. HOW do I get to Record and Execute my macros? 4. Select File > Options, then select Trust Center in the left-hand list and click “Trust Center Settings…” In the Trust Center dialog, select “Macro Settings” Disable all macros without notification: you won’t be able to enable or run macros when you open a workbook. I have uninstalled Outlook and reinstalled.