MrExcel Publishing
Your One Stop for Excel Tips & Solutions

deleting code

Posted by George on October 02, 2001 4:04 PM

I am new to this so forgive me if this is a stupid question. I copied code into my workbook to but how do I get it out now. No macro shows up to delete.

I have code running in a workbook (with 15 worksheets).

I want to remove the code but it seems I have to go to each and every sheet.

is this right. how can I do it quicker?

Posted by Qroozn on October 02, 2001 4:37 PM

the macro may have been attached to the worksheet rather than the workbook module.
try going into VBa/view/project explorer.
check there in the workbook and sheets for the code.

Posted by George on October 03, 2001 10:35 AM

I cannot figure it out. I thought I removed all references to the code and when I open excel it still gives me the Macro warning. If I go to tools:macri and try to run anything, there is nothing to run.

i am confused. more thoughts?