Thread
:
Removal of VBA from Excel not working
View Single Post
#
3
Posted to microsoft.public.excel.programming
charles
external usenet poster
Posts: 124
Removal of VBA from Excel not working
All of the tabs in the .xls that are in ThisWorkbook are also empty.
"Don Guillett" wrote:
How about code in the ThisWorkbook or sheet modules
--
Don Guillett
SalesAid Software
"Charles" wrote in message
...
After a number of macros are run in Excel I have code, as shown below, to
remove the VBA.
The problem I am having is that when the .xls is emailed, the emails is
being bounced from anti-virus systems saying that "
vb
script is detected".
When I go into the
VB
Script I see the "VBProject(Filename.xls)".
Although
there is nothing in it, I am wondering if this is causing the problems.
When I try to remove the VBProject by right clicking, the "Remove" is not
highlighted. I have checked off "trust
vb
script" as a preference in
excel.
The code is
Dim VBComp As VBComponent
Set VBComp = ThisWorkbook.VBProject.VBComponents("Module2")
ThisWorkbook.VBProject.VBComponents.Remove VBComp
End Sub
Note that the actual Module is removed, however, something in the
anti-virus
firewalls are picking up script.
Please advise of how to permanentlly remove.
Reply With Quote
charles
View Public Profile
Find all posts by charles