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 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.

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

That does not work. I don't have a clue what is wrong. Like I have stated
before, I have unistalled, reinstalled Office 2003 and have not had any luck.


"Dave Peterson" wrote:

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

When you write "that does not work", what do you mean?

Hitting alt-f11 or trying to reset the toolbars?



Mike Flory wrote:

That does not work. I don't have a clue what is wrong. Like I have stated
before, I have unistalled, reinstalled Office 2003 and have not had any luck.

"Dave Peterson" wrote:

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


--

Dave Peterson

Both. I have tried doing both.

"Dave Peterson" wrote:

When you write "that does not work", what do you mean?

Hitting alt-f11 or trying to reset the toolbars?



Mike Flory wrote:

That does not work. I don't have a clue what is wrong. Like I have stated
before, I have unistalled, reinstalled Office 2003 and have not had any luck.

"Dave Peterson" wrote:

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


--

Dave Peterson

Does this happen with every workbook you open?

What happens if you start excel and create a new macro, save that file, close
it, and reopen it?

If it only happens with older (xl2002) workbooks, it sounds as though the
workbooks were corrupted and excel could only open them after excel removed the
project.

I'm not sure what would be the best way to remedy this. Do you have access to
another pc that runs xl2003? If yes, do you get the same problem on that pc?

If it happens with the new workbook, then I'm at a loss. Maybe Help|Detect and
repair could help. When you reinstalled, you did check the stuff that Jim wrote
about:

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.


====
Can you try this?

Start excel in safe mode
close excel
windows start button|Run
excel /safe

try the alt-f11 and tools|macro|macros...

Does it work then?

===

Something that may reset that toolbar problem.

Close excel
windows start button|Search
look for *.xlb (where excel stores customized toolbars)
rename all the files you find to *.xlbOLD

Restart excel and see if that works. (This should have been the equivalent of
resetting the toolbar.)

===
Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

Something there may help.


Mike Flory wrote:

Both. I have tried doing both.

"Dave Peterson" wrote:

When you write "that does not work", what do you mean?

Hitting alt-f11 or trying to reset the toolbars?



Mike Flory wrote:

That does not work. I don't have a clue what is wrong. Like I have stated
before, I have unistalled, reinstalled Office 2003 and have not had any luck.

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson

I have unistalled and renistalled Office plenty of times, and still get the
same error.
I did run excel in safe mode, and that worked, but if you open excel
normally you get the error again.


"Dave Peterson" wrote:

Does this happen with every workbook you open?

What happens if you start excel and create a new macro, save that file, close
it, and reopen it?

If it only happens with older (xl2002) workbooks, it sounds as though the
workbooks were corrupted and excel could only open them after excel removed the
project.

I'm not sure what would be the best way to remedy this. Do you have access to
another pc that runs xl2003? If yes, do you get the same problem on that pc?

If it happens with the new workbook, then I'm at a loss. Maybe Help|Detect and
repair could help. When you reinstalled, you did check the stuff that Jim wrote
about:

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.


====
Can you try this?

Start excel in safe mode
close excel
windows start button|Run
excel /safe

try the alt-f11 and tools|macro|macros...

Does it work then?

===

Something that may reset that toolbar problem.

Close excel
windows start button|Search
look for *.xlb (where excel stores customized toolbars)
rename all the files you find to *.xlbOLD

Restart excel and see if that works. (This should have been the equivalent of
resetting the toolbar.)

===
Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

Something there may help.


Mike Flory wrote:

Both. I have tried doing both.

"Dave Peterson" wrote:

When you write "that does not work", what do you mean?

Hitting alt-f11 or trying to reset the toolbars?



Mike Flory wrote:

That does not work. I don't have a clue what is wrong. Like I have stated
before, I have unistalled, reinstalled Office 2003 and have not had any luck.

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson

What happened when you created a new workbook with macros?

Mike Flory wrote:

I have unistalled and renistalled Office plenty of times, and still get the
same error.
I did run excel in safe mode, and that worked, but if you open excel
normally you get the error again.

"Dave Peterson" wrote:

Does this happen with every workbook you open?

What happens if you start excel and create a new macro, save that file, close
it, and reopen it?

If it only happens with older (xl2002) workbooks, it sounds as though the
workbooks were corrupted and excel could only open them after excel removed the
project.

I'm not sure what would be the best way to remedy this. Do you have access to
another pc that runs xl2003? If yes, do you get the same problem on that pc?

If it happens with the new workbook, then I'm at a loss. Maybe Help|Detect and
repair could help. When you reinstalled, you did check the stuff that Jim wrote
about:

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.


====
Can you try this?

Start excel in safe mode
close excel
windows start button|Run
excel /safe

try the alt-f11 and tools|macro|macros...

Does it work then?

===

Something that may reset that toolbar problem.

Close excel
windows start button|Search
look for *.xlb (where excel stores customized toolbars)
rename all the files you find to *.xlbOLD

Restart excel and see if that works. (This should have been the equivalent of
resetting the toolbar.)

===
Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

Something there may help.


Mike Flory wrote:

Both. I have tried doing both.

"Dave Peterson" wrote:

When you write "that does not work", what do you mean?

Hitting alt-f11 or trying to reset the toolbars?



Mike Flory wrote:

That does not work. I don't have a clue what is wrong. Like I have stated
before, I have unistalled, reinstalled Office 2003 and have not had any luck.

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

I can create, and use macros in the Safe Mode, but when I try to run Excel
out of safe mode I get the error I mentioned below.

"Dave Peterson" wrote:

What happened when you created a new workbook with macros?

Mike Flory wrote:

I have unistalled and renistalled Office plenty of times, and still get the
same error.
I did run excel in safe mode, and that worked, but if you open excel
normally you get the error again.

"Dave Peterson" wrote:

Does this happen with every workbook you open?

What happens if you start excel and create a new macro, save that file, close
it, and reopen it?

If it only happens with older (xl2002) workbooks, it sounds as though the
workbooks were corrupted and excel could only open them after excel removed the
project.

I'm not sure what would be the best way to remedy this. Do you have access to
another pc that runs xl2003? If yes, do you get the same problem on that pc?

If it happens with the new workbook, then I'm at a loss. Maybe Help|Detect and
repair could help. When you reinstalled, you did check the stuff that Jim wrote
about:

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.


====
Can you try this?

Start excel in safe mode
close excel
windows start button|Run
excel /safe

try the alt-f11 and tools|macro|macros...

Does it work then?

===

Something that may reset that toolbar problem.

Close excel
windows start button|Search
look for *.xlb (where excel stores customized toolbars)
rename all the files you find to *.xlbOLD

Restart excel and see if that works. (This should have been the equivalent of
resetting the toolbar.)

===
Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

Something there may help.


Mike Flory wrote:

Both. I have tried doing both.

"Dave Peterson" wrote:

When you write "that does not work", what do you mean?

Hitting alt-f11 or trying to reset the toolbars?



Mike Flory wrote:

That does not work. I don't have a clue what is wrong. Like I have stated
before, I have unistalled, reinstalled Office 2003 and have not had any luck.

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

If it happens with just one workbook, then I think that workbook is bad.

If it happens each time you start excel, I'd go back and read Chip Pearson's
notes one more time.


Mike Flory wrote:

I can create, and use macros in the Safe Mode, but when I try to run Excel
out of safe mode I get the error I mentioned below.

"Dave Peterson" wrote:

What happened when you created a new workbook with macros?

Mike Flory wrote:

I have unistalled and renistalled Office plenty of times, and still get the
same error.
I did run excel in safe mode, and that worked, but if you open excel
normally you get the error again.

"Dave Peterson" wrote:

Does this happen with every workbook you open?

What happens if you start excel and create a new macro, save that file, close
it, and reopen it?

If it only happens with older (xl2002) workbooks, it sounds as though the
workbooks were corrupted and excel could only open them after excel removed the
project.

I'm not sure what would be the best way to remedy this. Do you have access to
another pc that runs xl2003? If yes, do you get the same problem on that pc?

If it happens with the new workbook, then I'm at a loss. Maybe Help|Detect and
repair could help. When you reinstalled, you did check the stuff that Jim wrote
about:

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.


====
Can you try this?

Start excel in safe mode
close excel
windows start button|Run
excel /safe

try the alt-f11 and tools|macro|macros...

Does it work then?

===

Something that may reset that toolbar problem.

Close excel
windows start button|Search
look for *.xlb (where excel stores customized toolbars)
rename all the files you find to *.xlbOLD

Restart excel and see if that works. (This should have been the equivalent of
resetting the toolbar.)

===
Chip Pearson has some notes on how to diagnose startup errors at:
http://www.cpearson.com/excel/StartupErrors.htm

Something there may help.


Mike Flory wrote:

Both. I have tried doing both.

"Dave Peterson" wrote:

When you write "that does not work", what do you mean?

Hitting alt-f11 or trying to reset the toolbars?



Mike Flory wrote:

That does not work. I don't have a clue what is wrong. Like I have stated
before, I have unistalled, reinstalled Office 2003 and have not had any luck.

"Dave Peterson" wrote:

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


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson