Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to CANCEL file SAVE PROMPT when MACRO is running? | Excel Discussion (Misc queries) | |||
How do I insert a prompt into an Excel macro? | Excel Discussion (Misc queries) | |||
Remove Subtotal In Macro Not Working | New Users to Excel | |||
Macro or Formula to remove Text from Cells | Excel Worksheet Functions | |||
how to enable macro | Excel Worksheet Functions |