Hi Zack,
They are all members of the Sheet's Shapes Collection so try something like
This should delete all your controls - if you only want particular types you'll need some selection logicFor Each s in activesheet.shapes s.delete next
Hi Zack,
They are all members of the Sheet's Shapes Collection so try something like
This should delete all your controls - if you only want particular types you'll need some selection logicFor Each s in activesheet.shapes s.delete next
Last edited by Aussiebear; 04-29-2023 at 09:50 PM. Reason: Added code tags
Enjoy,
Tony
---------------------------------------------------------------
Give a man a fish and he'll eat for a day.
Teach him how to fish and he'll sit in a boat and drink beer all day.
I'm (slowly) building my own site: www.WordArticles.com
Posting Permissions
Reply With Quote