Question about Microsoft Office Standard for PC
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?
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
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
Posted on Jan 02, 2017
Tips for a great answer:
Jun 22, 2011 | Microsoft Excel 2007 0882224152648 Full...
Jun 21, 2011 | Microsoft Office Professional 2007 Full...
Mar 17, 2011 | Microsoft Office Professional 2007 Full...
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
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.
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).
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.
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
Feb 21, 2011 | Computers & Internet
Jun 03, 2010 | Microsoft Office Access 2003 (077-02871)...
Oct 02, 2009 | Microsoft Office Professional 2007 Full...
Jun 22, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...
Mar 25, 2009 | Enfocus PitStop Professional 08 Full...
Mar 27, 2008 | Computers & Internet
4,562 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: