Kutools for Excel's Delete Illustrations & Objects can help you to delete only the text boxes in active worksheet, selected worksheets or the whole workbook without affecting other shapes. Press the F5 key to run this macro, and only the text boxes in current worksheet are deleted, see screenshots:ĭelete all text boxes in active worksheet, selected sheets or workbook with a handy feature VBA code: Delete all text boxes from current worksheet: Sub DeleteAllTextBoxes()ģ. Click Insert > Module, and paste the following macro in the Module window. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.Ģ. ![]() ![]() Sometime you may want to delete only the text boxes, but remains other shapes, such as charts, pictures, a VBA macro will be a good choice to delete all text boxes only in active worksheet, please do with the following steps:ġ. Note: This method will not only delete all text boxes, but also delete all kinds of shapes in active worksheet, including pictures, ClipArt, Shapes, SmartArt, charts, etc.ĭelete all text boxes in active worksheet with VBA code
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |