VBA Gone!


G

Guest

Hello:

A client was having an issue with Excel 2002, so we reinstalled Excel and
fixed the problem.

But, just now, he opened a spreadsheet that had a macro attached. The macro
apparently is gone. He says that Excel has removed the ability for him to
run the macro and access the Visual Basic Editor.

And, here is the error message that he gets: "This workbook has lost its
VBA project, ActiveX controls and any other programmability-related features."

Is there any way to get this back, even if a re-install of VBA is done?

Thanks!

childofthe1980s
 
Ad

Advertisements

G

Guest

All data files should be backed up elsewhere before reinstalling software.
The re-installation process tends to overwrite certain existing files.
 
J

Jim Rech

See my reply in Misc. You shouldn't multi-post.

--
Jim
message | Hello:
|
| A client was having an issue with Excel 2002, so we reinstalled Excel and
| fixed the problem.
|
| But, just now, he opened a spreadsheet that had a macro attached. The
macro
| apparently is gone. He says that Excel has removed the ability for him to
| run the macro and access the Visual Basic Editor.
|
| And, here is the error message that he gets: "This workbook has lost its
| VBA project, ActiveX controls and any other programmability-related
features."
|
| Is there any way to get this back, even if a re-install of VBA is done?
|
| Thanks!
|
| childofthe1980s
|
 
G

Guest

See my reply in Misc. You shouldn't multi-post.

--
Jim
message | Hello:
|
| A client was having an issue with Excel 2002, so we reinstalled Excel and
| fixed the problem.
|
| But, just now, he opened a spreadsheet that had a macro attached. The
macro
| apparently is gone. He says that Excel has removed the ability for him to
| run the macro and access the Visual Basic Editor.
|
| And, here is the error message that he gets: "This workbook has lost its
| VBA project, ActiveX controls and any other programmability-related
features."
|
| Is there any way to get this back, even if a re-install of VBA is done?
|
| Thanks!
|
| childofthe1980s
|
 
Ad

Advertisements

G

Gord Dibben

Then cross-post rather than multi-post.

Responders will then know to answer just one group or several.


Gord Dibben MS Excel MVP
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top