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

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


Direct link Reply with quote
 

Laura Stamp  Identity Verified
Germany
Local time: 18:30
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”


Direct link Reply with quote
 

Gerard de Noord  Identity Verified
France
Local time: 18:30
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


Direct link Reply with quote
 

Paolo Troiani  Identity Verified
Italy
Local time: 18:30
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?


Direct link Reply with quote
 
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


Direct link Reply with quote
 


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






WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »
Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »



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