Article ID: 282847 - View products that this article applies to.
This article was previously published under Q282847
If you disable Microsoft Visual Basic for Applications (VBA) and run Microsoft Excel, several Excel features in the following categories are unavailable:
The following features in Microsoft Excel are disabled when VBA is not enabled.
VBA Projects, XLM Macro Code, and ActiveX Controls
Uncompiled Add-ins (.xla files)An uncompiled add-in is an add-in file that was created by using VBA. If you open an uncompiled add-in, you receive the same warning as when you open a file that contains a regular VBA Project.
The following list contains some of the built-in add-ins that are unavailable:
Note Compiled add-ins such as .xll files, COM Add-ins, and Automation Add-ins are not affected by whether or not VBA is installed.
Menu items, toolbar buttons, and shortcut keys related to VBA
ACCRINT CUMIPMT HEX2BIN IMSUM PRICEMAT ACCRINTM CUMPRINC HEX2DEC INTRATE QUOTIENT AMORDEGRC DEC2BIN HEX2OCT ISEVEN RANDBETWEEN AMORLINC DEC2HEX IMABS ISODD RECEIVED BESSELI DEC2OCT IMAGINARY LCM SERIESSUM BESSELJ DELTA IMARGUMENT MDURATION SQRTPI BESSELK DISC IMCONJUGATE MROUND TBILLEQ BESSELY DOLLARDE IMCOS MULTINOMIAL TBILLPRICE BIN2DEC DOLLARFR IMDIV NETWORKDAYS TBILLYIELD BIN2HEX DURATION IMEXP NOMINAL WEEKNUM BIN2OCT EDATE IMLN OCT2BIN WORKDAY COMPLEX EFFECT IMLOG10 OCT2DEC XIRR CONVERT EOMONTH IMLOG2 OCT2HEX XNPV COUPDAYBS ERF IMPOWER ODDFPRICE YEARFRAC COUPDAYS ERFC IMPRODUCT ODDFYIELD YIELD COUPDAYSNC FACTDOUBLE IMREAL ODDLPRICE YIELDDISC COUPNCD FVSCHEDULE IMSIN ODDLYIELD YIELDMAT COUPNUM GCD IMSQRT PRICE COUPPCD GESTEP IMSUB PRICEDISC
For more information about not installing VBA support in Office, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/281953/ )Features turned off when Visual Basic for Applications is not installed
Article ID: 282847 - Last Review: September 18, 2011 - Revision: 5.0