Hi,
I'm trying to delete a macro that i wrote (and dont need anymore) from the file that i'm working on. I know that the macro is still there as each time i open the file i get asked if i want to disable or enable macros, however, when i go to the list of macros, its empty, as if there are no macros in this file.
I'm using Excel 2003.
Any help will be great!
Thanks a lot!

In the visual basic editor there will be a standard code module which your macro lived in. Remove it from the project by right clicking on it in the project explorer > Remove module (see screenshot attached). Also go through each of the Excel object modules and clear out any code in them (but don't remove them from the project).

Thanks a lot! I think that it worked.
I forgot to mention before that each time i tried to copy a graph from the excel worksheet to a power point presentation, after pasting the graph, excel brings up an error message saying: "Error accessing file. Network connection may have been lost". It doesnt happen if i try to copy/paste from a different excel file that didnt have a macro in it.
Is that related somehow to the macro problem that i had?
Thanks again for your help!

Hi,
I honestly don't know because it sounds like a fairly obscure Powerpoint issue to me, but I doubt it is directly related to the presence of VBA code within the Excel workbook. I guess you're in the best position to tell because you can experiment by adding/removing the code and copying the graph over? Does a reliable pattern emerge that you only get this error when that code is in the workbook?

Some Powerpoint 2003 users have reported this problem when certain controls are involved, so one thing to check would be if you have any controls on the graph?
Also make sure you have the latest Office service pack and hot fixes downloaded.

A powerpoint expert would be better placed to answer this which I am definitely not!

Thanks Colin. After playing with it i think that it has nothing to do with the VBA code... I'll try everyhing you mentioned and hopefully it'll work.