+ Reply to Thread
Results 1 to 6 of 6

Deleted files with Macros, Want to delete all macros which are hidden - how to fix?

  1. #1
    Registered User
    Join Date
    11-24-2009
    Location
    Pleasanton, CA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Exclamation Deleted files with Macros, Want to delete all macros which are hidden - how to fix?

    My excel is going nuts! I created some hidden macros and can see them but am not able to remove as I deleted the files!

    What is the best fix? Excel is sending out notices to other employees about sharing, I can't open excel AT ALL right now!

    Should I uninstall and reinstall Excel or Microsoft Suite? Will this get rid of the macros?

    Thx,

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Deleted files with Macros, Want to delete all macros which are hidden - how to fi

    Hi, are the macros in a shared workbook? Then you need to unshare first before you can do anything with them.
    If not in a shared workbook: what happens if you delete the code in the code window? What happens if you delete the module in the project?
    Are you sure the macros are stored in the files you deleted?

  3. #3
    Registered User
    Join Date
    11-24-2009
    Location
    Pleasanton, CA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Deleted files with Macros, Want to delete all macros which are hidden - how to fi

    yes, i'm sure i deleted the files. rats...

    how do i delete the code?

    I am just learning about how to use macros so interesting that this is happening..

    Thx,

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Deleted files with Macros, Want to delete all macros which are hidden - how to fi

    Do you see the code in the VBE? Then you have not deleted the files where the code is stored.

  5. #5
    Registered User
    Join Date
    11-24-2009
    Location
    Pleasanton, CA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Deleted files with Macros, Want to delete all macros which are hidden - how to fi

    no i don't see the code.

    Is there a way to delete the macros without the files?

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Deleted files with Macros, Want to delete all macros which are hidden - how to fi

    Is the code saved to PERSONAL.xls? If the macros are in an ordinary workbook then deleting the file should delete the macros
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1