How to enable macros in Excel 2007
Thread poster: Samuel Murray

Samuel Murray  Identity Verified
Netherlands
Local time: 19:46
Member (2006)
English to Afrikaans
+ ...
Jul 6, 2010

G'day everyone

I want to add a macro to Excel 2007. I have googled a bit and I enabled the Developer tab in Excel. I've tried macro security completely open and with and without trusted access. But... the "Record macro" and "Macros" options remain greyed out. I tried starting with a fresh new Excel file, but no luck. Does anyone know how to enable macros in Excel 2007?

Thanks
Samuel


 

Laura Stamp  Identity Verified
Germany
Local time: 19:46
German to Romanian
+ ...
Maybe this helps: Jul 6, 2010

Make sure you change the security settings.

Change Macro Settings to “Enable all macros” and

Change ActiveX settings to “Enable all controls without restrictions and without prompting”


 

Gerard de Noord  Identity Verified
France
Local time: 19:46
Member (2003)
German to Dutch
+ ...
Separate workbook Jul 6, 2010

Hi Samuel,

I think Excel wants you to store macros in a seperate workbook, Personal.xlsb, so maybe you should open that workbook with View/Window/Unhide and record your macros there.

Cheers,
Gerard


 

Paolo Troiani  Identity Verified
Italy
Local time: 19:46
Member (2010)
English to Italian
+ ...
Did you try with add-ins? Jul 6, 2010

When you open Excel, if you go on the "view" tab, do you have the "macro" greyed out?

If yes, then it seems like you did not activated VBA tools.
Try in Windows logo -> Excel Option -> Add-ins
Tick the boxes: Internet Assistant VBA and Analysis Tools - VBA.
In that window, at the bottom, you should also find the "go" button.
Click on it and the "Add-ins" dialog box should appear. There, activate "Internet Assistant VBA " and "Analysis Tools - VBA".

Close Excel, shut down and restart your PC.. does it change anything?


 

vnsakumar
India
How to enable macros in excel Nov 10, 2013

Hi, this video has step by step procedure to enable macros.

https://www.youtube.com/watch?v=KYmcKmeiyZo

Thanks


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How to enable macros in Excel 2007

Advanced search






SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »
SDL MultiTerm 2019
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2019 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2019 you can automatically create term lists from your existing documentation to save time.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search