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?
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.
Re: Office 2007 Standard - VBA not working
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!
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!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
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
Click the Microsoft Office Button , and then click Excel Options.
Click Trust Center, click Trust Center
Settings, and then click Macro Settings.
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
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.
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.
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......
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.