HELP: Refuse To Delete Macro applied to all open workbooks
I need help. I accidentally applied the RefuseToDelete Macro I saw online to all open workbooks. Now, I cannot delete any sheets of any excel file I have.
The code I use is: (from this forum. CLICK ME).
How will I remove this so my Excel will return to normal. I also attached the file where I am suppose to use the code to
Please Login or Register to view this content.
Thanks,
Linrose
Last edited by arlu1201; 09-12-2012 at 10:25 AM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I ran into this same issue; after removing all the code from a particular workbook, excel kept trying to access the "RefusetoDelete" macro within other general worksheets. To fix this, let the corrupted workbook load and use the worksheet_deactivate macro for both the worksheet_activate and worksheet_deactivate macros.
Add the following code to the corrupted workbook's worksheet:
Now activate and deactivate a worksheet after saving the changes within the corrupted worksheet. Delete should now be enabled.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks