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

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Legend:

    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 http://office.microsoft.com/en-us/excel/HP100141031033.aspx?pid=CH100648071033). 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 http://office.microsoft.com/en-us/excel/HA102189961033.aspx?pid=CH100645021033). 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 
  • Cheryl Whalen 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?

  • Cheryl Whalen 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 http://msdn2.microsoft.com/en-us/library....

    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:

    http://support.microsoft.com/kb/287567

    http://support.microsoft.com/kb/281953

    http://support.microsoft.com/kb/282847

    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:

    http://support.microsoft.com/kb/292103

    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"!

  • Cheryl Whalen 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

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

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...

1 Answer

Does office standard 2007 support VBA?


Yes it does, all versions of office 2007 supports VBA.

Oct 05, 2010 | Microsoft Office Standard for PC

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...

1 Answer

VBA and macros


To understand VBA, you download HERE and read it.

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

1 Answer

Writing macros


Anirbanmj

Macros for Excel and the rest of the office suite are based on Visual Basic for Applications (VBA) which is a subset of VB programming language.

If your not familier with this language then i would suggest "Googling" VBA Introduction or similar and have a look at some introductory info. If you are ok with VB then you can record doing a task you want to do and then look at the code generated to see what it has created.

Feb 02, 2008 | Business & Productivity Software

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

4,496 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...