Thread: VBA Gone!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default VBA Gone!

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

"childofthe1980s" wrote:

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