wizard to clear many invisible texboxes and images or shapes slow down Excel
sometimes there are several small empty textboxes with no border line that look invisible to the user. now if the user selects the cells that are behind those texboxes and copies them to a large range the number of the invisible textboxes multipllies.
i saw a workbook containing 30,000 textboxes and it was very slow, and the user dod not know about them.
a wizard that identifies the problem and suggest clearing them would help users to fix this.
maybe something lile this:
Dim P As Picture
Dim i As Integer
Dim picsN As Integer
picsN = ActiveSheet.Pictures.Count
For i = picsN To 1 Step -1