Enable/Disable macros

[Adam]

My file still asks if I want to enable or disable macros even though I have
deleted all macros.
Any Ideas?
/Adam

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
>-----Original Message-----
>My file still asks if I want to enable or disable macros
even though I have
>deleted all macros.
>Any Ideas?
>/Adam
>.
>

[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)


<anonymous@discussions.microsoft.com> wrote in message
news:5c2d01c5261f$d4488010$a501280a@phx.gbl...
> 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
> >-----Original Message-----
> >My file still asks if I want to enable or disable macros
> even though I have
> >deleted all macros.
> >Any Ideas?
> >/Adam
> >.
> >