How to enable macros in Excel 2007 Thread poster: Samuel Murray
|
|---|
Samuel Murray 
Netherlands
Local time: 20:54
Member (2006)
English to Afrikaans
+ ...
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
Germany
Local time: 20:54
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
France
Local time: 20:54
Member (2003)
English 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
Italy
Local time: 20:54
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".
... See more 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? ▲ Collapse
| | |
|
|
|
| | 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 | 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 » |
| | TM-Town | Manage your TMs and Terms ... and boost your translation business
Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
