remove enable macro prompt
 

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

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 Fileremove 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