Question about Microsoft Office Standard for PC

1 Answer

Office 2007 Standard - VBA not working

I've created a few VBA macros in MSO 2003. However now with the new look 2007 Standard - it seems that VBA is not available. I've opened the Developer Ribbon, but the Visual Basic button is greyed out. Also the macros causes an error message to appear & the macro doesn't run:

Visual Basic for Applications (VBA) is not installed on your computer. In this case, no VBA macro can be run, regardless of whether the macro has a valid certificate of trust. You or your administrator may have chosen not to install VBA, or the version of Microsoft Office that you are using may not install VBA by default. If your version of Microsoft Office does not provide VBA as an installable feature, you can upgrade to a version that provides VBA support.

I've set my macro security to "Enable All Macros" - no go. I've tried re-install, but there's not option for installing anything extra to the installation, there's not even an advanced button. It simply installs with a bunch of next buttons.

Is VBA totally removed from the MSO 2007 Standard Edition? Does this mean I have to get the Professional just so I can create some custom Excel formula?

Posted by on

  • 1 more comment 
  • irneb
    irneb Apr 21, 2008

    Thanks for the reply, unfortunately I've tried this but it still gives a greyed-out Visual Basic button:

    My security settings are also set as low as possible (as discussed in the Help):

    And then Word gives this error about 5 times for each open of a DOC / DOCX:

  • irneb
    irneb Apr 22, 2008

    VBA is greyed out no matter what, new, started without any file opened, saved as to XLSM, default to XLSM, open an XLS with VBA code as made in 2003 (same error opens here as in Word), then saveas to XLSM & reopen - still same problem.

    I'll try re-installing MSO then re-doing all those hotfixes. Thanks for the advice ... although I should've thought of that myself ...

  • irneb
    irneb Apr 24, 2008

    Thank you very much ... total uninstall & then install as if new worked! Repair didn't do a thing & the VBA was checked when I looked at the Add Components before. Maybe there's something that's not handled by the repair install?

    But anyway, my problem's gone thank you!



1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 10 achievements.


    An expert that got 5 achievements.


    An expert who has written 200 answers of more than 400 characters.

  • Expert
  • 359 Answers

There is no indication that VBA should not work in all versions of Excel. There is a new file extension (xlsm), which is used to activate macros and allow usage. If you have, perhaps, opened and saved with incorrect extension (new is xlsx), VBA may be unavailable. Try to resave it with the changed extension. It seems likely that this is the issue (reference Also, if you make sure your Save As option is set at xlsm, this should help to prevent problems. VBA should not be an issue in any version of Excel and custom functions ARE available (see It should be as simple as changing the extension, and I would suggest changing the default save as option. If this helps, please rate "FixYa"! Thanks!

Posted on Apr 21, 2008

  • 1 more comment 
  • Anonymous Apr 22, 2008

    Does the VBA option appear grayed out if you open up a brand new document, having set your default file save as option at xlsm? Or was this file opened before these settings were put in place? Then, I would ask if you have contacted MS at all, and if this is an OEM or full retail purchased product? As the issue obviously affects Word as well as Excel (which wasn't in your original post), it could be a faulty installation of Office, or at least the VBA portion. Have you applied all updates / hotfixes?

  • Anonymous Apr 23, 2008

    Believe it or not, I have spent the last 2+ hours writing a very long post for you, referencing numerous web pages, and when I hit "More Options" in the post, to align the comments just placed in the post, it disappeared. I have to work now, so I can't take time at this moment to rework it. Sorry! Long story short - our web site here didn't do us any favors when it dumped my whole post!

    Can you verify that your problem is unchanged, before I go through all that work again? I really want to help but have now lost more than 2 hours of work on it!

    The last thing posted before it was dumped was a suggestion from

    If you could go there and make sure that the steps there don't work, that would be helpful. I also had several references in regard to the Word issue, and VBA/Excel problems. I will try to reproduce those tonight. For now, I am forced to simply list for you some of the references I previously included with comments, instructions, and so forth.

    Take a look at these, which seem to indicate that VBA was truly either not installed or has been disabled:

    Is it at all possible this happened - inadvertently, or perhaps some option was not really visible...?

    Could the Word issue be related to IE and having another copy open in Word? This is primarily where the error shows up:

    Other references I cited previously in this regard evidence that this has been an "acknowledged issue" since at least Word 2002 - so MS apparently thinks it's OK to leave a bug there fo at least 6 years / 3 versions, and take no action to correct it.

    Sorry the detail I had earlier is gone - but this is the basic essence, I think. I will recheck my research after further info from you, if you want me to continue to work on it. Work is calling my name... Thanks for working with me to get to a rating of "FixYa"!

  • Anonymous Apr 24, 2008

    I am SO THRILLED!! As you could tell, I took this one to heart and really did a lot of work on it, so I am overjoyed that it now is working. Since you are obviously very reliant on the VBA features (and I understand the frustration when it doesn't work), it is just not acceptable for the function not to work - every time! Good luck - if ever there is anything else I can help with, just "post"!



1 Suggested Answer

  • 2 Answers


Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

Hi Team, I have created macro in MS Excel2007 and after executing macro output file will be created MS Excel2003. Once MS Excel2003 file closed and reopen all the formating lost. How can overcome this...

It is unlikely that you can really overcome this as Office 2003 and Office 2007 have completely different file formats and structures. But if you output it to an Office 2007 file and use the Microsoft converter for Office 2003 than it may work. The converter can be found here

Jun 22, 2011 | Microsoft Excel 2007 0882224152648 Full...

1 Answer

I am using microsoft excel 2007, the code is not running, the macro was disabled.. How to enable the macro...?

From the excel help file

  1. Click the Microsoft Office Button o12filemenubutton_za10077102.gif, and then click Excel Options.
  2. Click Trust Center, click Trust Center Settings, and then click Macro Settings.
  3. Click the options that you want:
    • Disable all macros without notification Click this option if you don't trust macros. All macros in documents and security alerts about macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system.
    • Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.
    • Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.
    • Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.
    • Trust access to the VBA project object model This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box.

Jun 21, 2011 | Microsoft Office Professional 2007 Full...

2 Answers

What is exel sheet extension in office 2010 ?

Excel Workbook


The default Excel file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Workbook


Uses the same basic XML format as the Excel Workbook, but can store VBA macro code. Users saving an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in Excel 4.0) are prompted to use this file format.

Excel Template


The default file format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro sheets (.xlm files in Excel 4.0).

Excel Macro-Enabled Template


Can contain a VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0). Workbooks created from this template inherit the VBAProject part or Excel 4.0 macro sheets that exist in the template.

Excel Add-In


A supplemental program that runs additional code. Excel add-ins use the Open XML file format to store data, and they support using VBA projects and Excel 4.0 macro sheets.

Feb 21, 2011 | Computers & Internet

1 Answer

What is the extension file name for a microsoft access file?

According to Wikipedia:-

Access Project .adp
Access Blank Project Template .adn
Access Database (2007) .accdb
Access Database Runtime (2007) .accdr
Access Database Template (2007) .accdt
Access Database (2003 and earlier) .mdb
Access Database, used for addins (2,95,97), previously used for workgroups (2). .mda
Access Database Template (2003 and earlier) .mdt
Access Workgroup, database for user-level security. .mdw
Access (SQL Server) detached database (2000) .mdf
Protected Access Database, with compiled VBA (2003 and earlier) .mde
Protected Access Database, with compiled VBA (2007) .accde
Windows Shortcut: Access Macro .mam
Windows Shortcut: Access Query .maq
Windows Shortcut: Access Report .mar
Windows Shortcut: Access Table .mat
Windows Shortcut: Access Form .maf

Jun 03, 2010 | Microsoft Office Access 2003 (077-02871)...

1 Answer

Hi, I've go a VBA macro that runs fine in Excel 2003 but I get the Run time error '-2147467259 (80004005)': Method 'MaximumScale' of object 'Axis' failed I'll send you the macro if you want. A small t...

I assume you mean that it's fine in 2003 but errors in 2007? If this is the case, then you may want to check the protection on the sheet. With 2007, you will run into this error everytime the macro tries to update a password protected sheet or portion of a sheet.

Hope this helps!

Oct 02, 2009 | Microsoft Office Professional 2007 Full...

2 Answers

VBA and macros

SLA consultants in India. The training program is intelligently designed by industry experts to provide hands on experience and in-depth knowledge to the participant regarding MA Access database and Visual Basic for application programming. The training will use real time practical sessions and live projects and assignments to offer you a better understanding of both the tools.


Jun 22, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

3 Answers

Problem opening Access Database-upgrade from Access 2003 to 2007

It seems that you have your Database(.mdb) file is created in Office 2003.... thats why you are unable to open it in 2007.... I faced the same problem.... then I came back to 2003 in order to use our database......

Mar 25, 2009 | Enfocus PitStop Professional 08 Full...

1 Answer

VBA not working in all Office products

There is setting for VBA in office 2007.
Go to Excel options-->Trust center--> trust center setting and configure the required settings

Jan 04, 2009 | Microsoft Office Standard for PC

2 Answers

Excel 2007 (Exporting info from MRI)

I suggest that you should you Office 2003 much better. office 2007 has a very hard time to use, even if its user friendly. but i dont waste time just to configure such DELICATE Problems like office 2007. if theres any problem just contact me sir/mam. thanks!

Mar 27, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

4,562 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts


Level 3 Expert

13434 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18429 Answers

Alun Cox

Level 3 Expert

2679 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides