accidently added a macro

[leecavturbo]

how can i remove a macro from a worksheet/book?
i don't know anything about macros if that helps
thx

 

[Stormseed]

What is your macro, in other words, is it a module or some code in an Excel Event ? Can you post the code ?

 

[RoryA]

Right-click a worksheet tab, and choose View Code. This will open the VBEditor. At the top left, you should see the Project Explorer (looks a bit like Windows Explorer) with all the open workbooks listed. If you see a Modules section in your workbook, click the + symbol to expand it if necessary, then right-click each module and choose Remove Modulen (don't bother exporting unless you want to save the code). Once you have removed all the modules, close the VB Editor and save your workbook.

 

[leecavturbo]

here is what i have. there was a module in the at the bottom which i deleted
but when i open the workbook it still asks to enable marcos?
.

 

[Stormseed]

Did you check for code which may exist in the Workbook/Worksheet events ?

Edit: I am sorry, I am unable to view the picture you have posted due to office network restrictions.

 

[leecavturbo]

Did you check for code which may exist in the Workbook/Worksheet events ?

how do i do that?
i don't think there is any code in cells if thats what you mean?

 

[RoryA]

Delete the code you have displayed in that window (the Worksheet_SelectionChange event code) then resave the workbook.

 

[Norie]

And check all the other modules too.

 

[Ivan F Moala]

In your image above, Delete all that text on the right Pane = WorkSheet_Selectionchange ....

 

[leecavturbo]

ok deleted all that text and checked the other 6 sheets which show no code now.
but still asks to run macros when opened?