Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet that had a number of macros in. I used this to create
another (SP_B), then deleted the original sheets in an attempt to break all links. I also deleted all the macros. Now, when I "Move/Copy" a single sheet from SP_B into another spreadsheet, all the macros which have been deleted, come with it. How can I purge the original to get rid of any reference to the deleted macros. They don't actually load in because they don't exist. They must have a pointer identifying them some place. Help me Obi-wan. You're my only hope. |
#2
![]() |
|||
|
|||
![]()
What probably happened is that you deleted the macros but not the
modules in which those macros existed. To do so, open the workbook then open VBA by pressing Alt-F11. In the tree listing on the left, look for the word "Modules". Right click on it and choose to remove it. If you get a prompt to export or backup the module, select no. That should fully purge the macros. - John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protect macros? | Excel Discussion (Misc queries) | |||
Deleting Macros | Excel Worksheet Functions | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) |