Purge macros
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.
|