To work around this issue without installing VBA, follow
these steps:
- Click Start, point to Settings, and then click Control Panel.
- Double-click Add/Remove Programs.NOTE: Because there are several versions of Microsoft Windows, the
following steps may be different on your computer. If they are, see your
product documentation to complete these
steps.
- In the Currently installed programs list,
click Microsoft Office XP or Microsoft Excel 2002, and then click Change.
- Click Add or Remove Features, and then
click Next.
- In the Features to install list, click the
plus sign (+) next to Office Shared Features, click the icon next to Visual Basic for
Applications, and then click Not Available.
- Click Update.
- You may receive a dialog box explaining what features of
Microsoft Office require VBA to be installed. If you do not need these
features, click Yes to remove any existing installation of VBA and to prevent VBA
from being installed in the future.
- When Office XP setup is complete, click OK.
- In the Add/Remove Programs dialog box, click Close.
If the VBA feature is not installed, you must install
it. To do so, follow these steps:
- In Control Panel, double-click Add or Remove
Programs.
- In the Currently installed programs list,
click Microsoft Office XP or click Microsoft Excel
2002, and then click Change.
- Click Add or Remove Features, and then
click Next.
- In the Features to install list, expand
Office Shared Features, click the icon next to Visual
Basic for Applications, click Run from My Computer,
and then click Update.
After you follow these steps, start Excel to see if VBA is
functioning.