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

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






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



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