remove enable macro prompt

R

Redden

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

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
 
Top