I have recently upgrade from Office XP to Office 2003. I'm running XP Pro
w/SP2 and all of the updates for Windows and Office. Here is the problem I'm
having:

When trying to run macros in Excel 2003 I get the following error message:
"This workbook has lost its VBA project, ActiveX controls and any other
programmability-related features."
Not sure why I'm getting this message, everything is installed from the
CD. I have done all of the troubleshooting listed on Microsoft's website,
and nothing seems to help. But if I go back to Excel 2002 and run the same
program I don't have any problems.
Any thoughts?

It sounds as if VBA was not installed or it has been turned off (which can
be done with a registry entry). More likely the former. What happens when
you try to enter the VBE (Alt-F11)? If you get an error then try running
Office setup again and under Office Shared Features make sure Visual Basic
for Applications is selected for installation.

--
Jim Rech
Excel MVP
"Mike Flory" <Mike wrote in message
...
|I have recently upgrade from Office XP to Office 2003. I'm running XP Pro
| w/SP2 and all of the updates for Windows and Office. Here is the problem
I'm
| having:
|
| When trying to run macros in Excel 2003 I get the following error
message:
| "This workbook has lost its VBA project, ActiveX controls and any other
| programmability-related features."
| Not sure why I'm getting this message, everything is installed from the
| CD. I have done all of the troubleshooting listed on Microsoft's website,
| and nothing seems to help. But if I go back to Excel 2002 and run the
same
| program I don't have any problems.
| Any thoughts?
|

VBA was installed when I setup Office 2003. I have unistalled and
reinstalled Office 2003, about 3 or 4 times and nothing seems to happen. I
don't have the option to do Alt-F11 it is grayed out.

"Jim Rech" wrote:

It sounds as if VBA was not installed or it has been turned off (which can
be done with a registry entry). More likely the former. What happens when
you try to enter the VBE (Alt-F11)? If you get an error then try running
Office setup again and under Office Shared Features make sure Visual Basic
for Applications is selected for installation.

--
Jim Rech
Excel MVP
"Mike Flory" <Mike wrote in message
...
|I have recently upgrade from Office XP to Office 2003. I'm running XP Pro
| w/SP2 and all of the updates for Windows and Office. Here is the problem
I'm
| having:
|
| When trying to run macros in Excel 2003 I get the following error
message:
| "This workbook has lost its VBA project, ActiveX controls and any other
| programmability-related features."
| Not sure why I'm getting this message, everything is installed from the
| CD. I have done all of the troubleshooting listed on Microsoft's website,
| and nothing seems to help. But if I go back to Excel 2002 and run the
same
| program I don't have any problems.
| Any thoughts?
|

Try hitting alt-f11 using the keyboard.



Mike Flory wrote:

VBA was installed when I setup Office 2003. I have unistalled and
reinstalled Office 2003, about 3 or 4 times and nothing seems to happen. I
don't have the option to do Alt-F11 it is grayed out.

"Jim Rech" wrote:

It sounds as if VBA was not installed or it has been turned off (which can
be done with a registry entry). More likely the former. What happens when
you try to enter the VBE (Alt-F11)? If you get an error then try running
Office setup again and under Office Shared Features make sure Visual Basic
for Applications is selected for installation.

--
Jim Rech
Excel MVP
"Mike Flory" <Mike wrote in message
...
|I have recently upgrade from Office XP to Office 2003. I'm running XP Pro
| w/SP2 and all of the updates for Windows and Office. Here is the problem
I'm
| having:
|
| When trying to run macros in Excel 2003 I get the following error
message:
| "This workbook has lost its VBA project, ActiveX controls and any other
| programmability-related features."
| Not sure why I'm getting this message, everything is installed from the
| CD. I have done all of the troubleshooting listed on Microsoft's website,
| and nothing seems to help. But if I go back to Excel 2002 and run the
same
| program I don't have any problems.
| Any thoughts?
|




--

Dave Peterson

I have a keyboard. What I mean is when you go to tools, macros, the VBA
(Alt-F11), fucntion is grayed out.

"Dave Peterson" wrote:

Try hitting alt-f11 using the keyboard.



Mike Flory wrote:

VBA was installed when I setup Office 2003. I have unistalled and
reinstalled Office 2003, about 3 or 4 times and nothing seems to happen. I
don't have the option to do Alt-F11 it is grayed out.

"Jim Rech" wrote:

It sounds as if VBA was not installed or it has been turned off (which can
be done with a registry entry). More likely the former. What happens when
you try to enter the VBE (Alt-F11)? If you get an error then try running
Office setup again and under Office Shared Features make sure Visual Basic
for Applications is selected for installation.

--
Jim Rech
Excel MVP
"Mike Flory" <Mike wrote in message
...
|I have recently upgrade from Office XP to Office 2003. I'm running XP Pro
| w/SP2 and all of the updates for Windows and Office. Here is the problem
I'm
| having:
|
| When trying to run macros in Excel 2003 I get the following error
message:
| "This workbook has lost its VBA project, ActiveX controls and any other
| programmability-related features."
| Not sure why I'm getting this message, everything is installed from the
| CD. I have done all of the troubleshooting listed on Microsoft's website,
| and nothing seems to help. But if I go back to Excel 2002 and run the
same
| program I don't have any problems.
| Any thoughts?
|




--

Dave Peterson

Jim Rech wanted to know if you could get to the VBE using alt-f11. If that
works, then maybe it's just a toolbar problem (resetting it may fix it).

If alt-f11 didn't work, then the solution may not be as easy.

tools|customize|toolbars|select worksheet menubar|click reset
if alt-f11 works.

You will lose any other customizations to that toolbar, though.

Mike Flory wrote:

I have a keyboard. What I mean is when you go to tools, macros, the VBA
(Alt-F11), fucntion is grayed out.

"Dave Peterson" wrote:

Try hitting alt-f11 using the keyboard.



Mike Flory wrote:

VBA was installed when I setup Office 2003. I have unistalled and
reinstalled Office 2003, about 3 or 4 times and nothing seems to happen. I
don't have the option to do Alt-F11 it is grayed out.

"Jim Rech" wrote:

It sounds as if VBA was not installed or it has been turned off (which can
be done with a registry entry). More likely the former. What happens when
you try to enter the VBE (Alt-F11)? If you get an error then try running
Office setup again and under Office Shared Features make sure Visual Basic
for Applications is selected for installation.

--
Jim Rech
Excel MVP
"Mike Flory" <Mike wrote in message
...
|I have recently upgrade from Office XP to Office 2003. I'm running XP Pro
| w/SP2 and all of the updates for Windows and Office. Here is the problem
I'm
| having:
|
| When trying to run macros in Excel 2003 I get the following error
message:
| "This workbook has lost its VBA project, ActiveX controls and any other
| programmability-related features."
| Not sure why I'm getting this message, everything is installed from the
| CD. I have done all of the troubleshooting listed on Microsoft's website,
| and nothing seems to help. But if I go back to Excel 2002 and run the
same
| program I don't have any problems.
| Any thoughts?
|




--

Dave Peterson


--

Dave Peterson

It sounds like there may be an issue with the VBA project in your Excel 2003 workbook. Here are some steps you can try to resolve the issue:

1. Check that the VBA project is still intact in your workbook. To do this, open the workbook and press ALT + F11 to open the VBA editor. In the Project Explorer pane on the left-hand side, check that your workbook is listed and expand it to see if any modules or forms are present. If they are not, then the VBA project may have been deleted or corrupted.
2. Try repairing your Office 2003 installation. Go to Control Panel Add or Remove Programs, select Microsoft Office 2003 and click on Change. Choose the Repair option and follow the prompts to repair your installation. This may fix any issues with missing or corrupted files.
3. Check that your security settings are not preventing the VBA project from running. Go to Tools Macro Security and make sure that the security level is set to Medium or Low. If it is set to High, then macros may be disabled and you will need to change the setting to allow macros to run.
4. Try copying the VBA project from your Excel 2002 workbook to your Excel 2003 workbook. Open both workbooks and press ALT + F11 to open the VBA editor. In the Project Explorer pane, right-click on the workbook name in your Excel 2002 workbook and select Export File. Save the file to a location on your computer. Then, in your Excel 2003 workbook, right-click on the workbook name and select Import File. Select the file you just exported from your Excel 2002 workbook and click Open. This should copy the VBA project from your Excel 2002 workbook to your Excel 2003 workbook.

I hope these steps help you resolve the issue with your VBA project in Excel 2003. Let me know if you have any other questions or if these steps do not work for you.