PDA

View Full Version : partially clearing temporary macros


CREvans
05-08-2008, 11:25 AM
Other than explicitly specifying what temporary macros to delete by name, is there a way to use a wildcard to delete a range of temporary macros?

I'm currently using this:

Application.Macros(vbldMacroTemporary).Clear

But this clears out all temporary macros, even those I'd like to keep around, if possible.

kinook
05-08-2008, 11:29 AM
The Remove method of the Macros collection does not accept a wildcard. To selectively delete some macros, you would need to use script code to remove by name as needed.