#1
|
|||
|
|||
Excel 2013 Record Macro greyed out
Moved work book from Office 2010 to Office 2013. Macros do not run and unable to record new macros as "Record Macro" is greyed out.
|
#2
|
||||
|
||||
Check your macro security setting, under Developer|Macro Security. It should be set to 'Disable all macros with notification" or 'Disable all macros except digitally signed macros".
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
Byron |
#4
|
||||
|
||||
Do you have any 3rd-party addins running? See under File|Options|Addins.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Quote:
Thanks again for the suggestions. Byron |
#6
|
||||
|
||||
I assume that the recorder is greyed out all of the time and not for a specific workbook.
I wonder if some required installation options were unchecked when you installed Office 2013? I'd be surprised if this is the case because you said that the macro recorder is OK in MS Word 2013, but it's still worth a look. Re-insert the installation disc, choose Add or Remove Features and ensure that Visual Basic for Applications and Digital Certificate for VBA projects under the Office Shared Features are installed. |
#7
|
|||
|
|||
Quote:
Thanks for your time on this. Have a great weekend, Byron |
#8
|
|||
|
|||
Three years on and this last option worked. Oddly those features showed as installed already, but attempting to install them again fixed it.
|
Tags |
record macro greyed out |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Which ODF/ .odt version is word 2010, 2013 preview & eventually 2013 full using? | semiotically | Word | 8 | 11-08-2012 05:44 PM |
Options in Office 2013 greyed out | extracampine | Excel | 1 | 09-17-2012 08:39 PM |
avoid duplicete record and merge the record with the existed record | hemant.behere | Excel | 0 | 01-10-2012 02:53 AM |
how do you record a macro | boogers | Office | 1 | 10-25-2011 05:19 AM |
Is it possible to make Word link to the last record in Excel | stephen_pen | Word | 0 | 09-22-2011 11:00 PM |