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

Samuel Murray  Identity Verified
Netherlands
Local time: 09:20
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: 09:20
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: 09:20
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: 09:20
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






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



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