remove enable macro prompt

[Redden]

I have a spreadsheet which originally had macros attached - now all deleted. Spreadsheet is still promting for enabling of macros when being opened - how do i stop it happening?

[FSt1]

hi,
You may have deleted the macros but the modules are still there.
open the VB editor (alt +F11). on the left, expand your vb project(file name).
click on any mondule that may be there then click File>remove module.
remove all modules in the vb Project. that will stop the enable macro message.

Regards
FSt1

"Redden" wrote:

>
> I have a spreadsheet which originally had macros attached - now all
> deleted. Spreadsheet is still promting for enabling of macros when
> being opened - how do i stop it happening?
>
>
> --
> Redden
> ------------------------------------------------------------------------
> Redden's Profile: http://www.excelforum.com/member.php...o&userid=26370
> View this thread: http://www.excelforum.com/showthread...hreadid=396410
>
>