Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Gone!
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Gone!
See my reply in Misc. You shouldn't multi-post.
-- Jim "childofthe1980s" wrote in 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 | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Gone!
On multi-posting, I have to get the answer somehow. I always go the extra
mile for my clients. "Jim Rech" wrote: See my reply in Misc. You shouldn't multi-post. -- Jim "childofthe1980s" wrote in 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 | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Gone!
And irritate others by wasting their time.
childofthe1980s wrote: On multi-posting, I have to get the answer somehow. I always go the extra mile for my clients. "Jim Rech" wrote: See my reply in Misc. You shouldn't multi-post. -- Jim "childofthe1980s" wrote in 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 | -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Gone!
Then cross-post rather than multi-post.
Responders will then know to answer just one group or several. Gord Dibben MS Excel MVP On Wed, 14 Mar 2007 11:59:35 -0700, childofthe1980s wrote: On multi-posting, I have to get the answer somehow. I always go the extra mile for my clients. "Jim Rech" wrote: See my reply in Misc. You shouldn't multi-post. -- Jim "childofthe1980s" wrote in 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 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|