#All shapes free
Free to try with no limitation in 30 days. Kutools for Excel includes more than 300 handy Excel tools. If you only want to remove the auto shapes from the worksheet, Kutools for Excel's Delete Illustrations & Object can help you delete specific shapes in active worksheet, selected worksheets or the whole workbook with only one click. This VBA macro can delete all kinds of shapes in active worksheet, including pictures, ClipArt, Shapes, SmartArt, charts, Text boxes, etc.ĭelete all autoshapes in worksheet or workbook with Kutools for Excel This VBA macro can only delete all shapes in active worksheet.Ģ. Then you will see all shapes in active worksheet are deleted quickly.ġ. Step 3: Press the F5 key to run this macro. VBA: delete all shapes in active worksheet. Step 2: Click Insert > Module, and paste the following macro in the Module window. Step 1: Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window. Using VBA macro can help you delete all auto shapes in active worksheet quickly. Applying this method will remove other objects besides auto shapes if there are not only autoshapes object in the worksheet.ĭelete all autoshapes in active worksheet with VBA Note: Objects contain autoshapes, pictures, clip arts and so on.
Then click Backspace button to remove all autoshapes. Check Objects, and then click Ok, it will select all objects, see screenshot:ģ.
Click F5 or Ctrl+G to display Go To dialog and click Special., see screenshot:Ģ. If there are only one kind of objects-autoshapes in a worksheet, you can delete all autoshapes with Go To function.ġ. Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!
0 kommentar(er)
