G
Guest
My file still asks if I want to enable or disable macros even though I have
deleted all macros.
Any Ideas?
/Adam
deleted all macros.
Any Ideas?
/Adam
G
Guest
Hi Adam,
the reason for this is that although the macros have been
deleted a module folder still exists. In the VB editor
you will see a module folder. Expand this, then right
click on the module shown (probably 'Module1') and
choose 'Remove..'. Click 'No' in the next dialog and
Save. You won't see the macro dialog when you re-open the
file.
Regards,
TonyM
the reason for this is that although the macros have been
deleted a module folder still exists. In the VB editor
you will see a module folder. Expand this, then right
click on the module shown (probably 'Module1') and
choose 'Remove..'. Click 'No' in the next dialog and
Save. You won't see the macro dialog when you re-open the
file.
Regards,
TonyM
B
Bob Phillips
Adam,
You could run this code on the workbook
Dim vbMod As Object
For Each vbMod In ActiveWorkbook.VBProject.VBComponents
Select Case vbMod.Type
Case 1, 2, 3: 'module, class, userform
ThisWorkbook.VBProject.VBComponents.remove vbMod
Case Else 'ThisWorkbook, sheet modules
With vbMod.CodeModule
.DeleteLines 1, .CountOfLines
End With
End Select
Next vbMod
Make sure that you don't leave it in the workbook though
--
HTH
RP
(remove nothere from the email address if mailing direct)
You could run this code on the workbook
Dim vbMod As Object
For Each vbMod In ActiveWorkbook.VBProject.VBComponents
Select Case vbMod.Type
Case 1, 2, 3: 'module, class, userform
ThisWorkbook.VBProject.VBComponents.remove vbMod
Case Else 'ThisWorkbook, sheet modules
With vbMod.CodeModule
.DeleteLines 1, .CountOfLines
End With
End Select
Next vbMod
Make sure that you don't leave it in the workbook though
--
HTH
RP
(remove nothere from the email address if mailing direct)