Results 1 to 5 of 5

Thread: Deleting Macros

  1. #1
    Join Date
    Mar 2010
    Posts
    30

    Unanswered: Deleting Macros

    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!

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    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).
    Attached Thumbnails Attached Thumbnails Remove Module.png  

  3. #3
    Join Date
    Mar 2010
    Posts
    30
    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!

  4. #4
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,
    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?
    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!

  5. #5
    Join Date
    Mar 2010
    Posts
    30
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •