Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-01-2013, 12:25 PM
av8r av8r is offline Windows 8 Office 2013
Novice
 
Join Date: Feb 2013
Posts: 4
av8r is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 02-01-2013, 06:20 PM
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 8,478
macropod has a spectacular aura aboutmacropod has a spectacular aura aboutmacropod has a spectacular aura about
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 02-01-2013, 06:29 PM
av8r av8r is offline Windows 8 Office 2013
Novice
 
Join Date: Feb 2013
Posts: 4
av8r is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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".
Thanks Paul, tried both without any luck. Strange thing is my 2013 Word is set as you describe and Macros work fine, just not in Excel which has them greyed out.

Byron
Reply With Quote
  #4  
Old 02-01-2013, 08:18 PM
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 8,478
macropod has a spectacular aura aboutmacropod has a spectacular aura aboutmacropod has a spectacular aura about
Default

Do you have any 3rd-party addins running? See under File|Options|Addins.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 02-02-2013, 06:58 AM
av8r av8r is offline Windows 8 Office 2013
Novice
 
Join Date: Feb 2013
Posts: 4
av8r is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Do you have any 3rd-party addins running? See under File|Options|Addins.
I did have Adobe PDF maker running. I disabled it but still no joy.

Thanks again for the suggestions.

Byron
Reply With Quote
  #6  
Old 02-02-2013, 10:47 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline Windows 7 32bit Office 2010 32bit
Microsoft MVP
 
Join Date: Jan 2011
Location: UK
Posts: 382
Colin Legg will become famous soon enough
Default

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.
Reply With Quote
  #7  
Old 02-02-2013, 12:58 PM
av8r av8r is offline Windows 8 Office 2013
Novice
 
Join Date: Feb 2013
Posts: 4
av8r is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
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.
Colin, your suggestion got me on the right track. With Office 2013 installation was a download of a set up program. I reran the set up program and now all is well!! :-)

Thanks for your time on this.

Have a great weekend,

Byron
Reply With Quote
Reply

Tags
record macro greyed out
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


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 04: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 01:53 AM
how do you record a macro boogers Office 1 10-25-2011 05:19 AM
Is it possible to make Word read the last record in Excel stephen_pen Word 0 09-22-2011 11:00 PM


All times are GMT -7. The time now is 09:08 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft