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