Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel spreadsheet is corrupted with multiple text boxes?
I have a Excel spreadsheet that I use for scheduling. I have a problem with
multiple (empty) text boxes appearing over multiple cells in the spreadsheet. Is this a bug? What is a quicker way to delete all of the unwanted text box frames? At present, I am selecting the box, hitting the 'Delete' key and then selecting the box directly underneath. There are up to 50 text box frames piled one on top of the other that I am deleting individually! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel spreadsheet is corrupted with multiple text boxes?
If the only Shapes on your worksheet are these unwanted Text Boxes, then try
this tiny macro: Sub CleanUp() Dim s As Shape For Each s In ActiveSheet.Shapes s.Delete Next End Sub Macros are very easy to install and use: 1. ALT-F11 brings up the VBE window 2. ALT-I ALT-M opens a fresh module 3. paste the stuff in and close the VBE window If you save the workbook, the macro will be saved with it. To use the macro from the normal Excel window: 1. ALT-F8 2. Select the macro 3. Touch Run To remove the macro: 1. bring up the VBE window as above 2. clear the code out 3. close the VBE window To learn more about macros in general, see: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Gary''s Student - gsnu200855 "Jim_C" wrote: I have a Excel spreadsheet that I use for scheduling. I have a problem with multiple (empty) text boxes appearing over multiple cells in the spreadsheet. Is this a bug? What is a quicker way to delete all of the unwanted text box frames? At present, I am selecting the box, hitting the 'Delete' key and then selecting the box directly underneath. There are up to 50 text box frames piled one on top of the other that I am deleting individually! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to select multiple text boxes in excel for formatting | New Users to Excel | |||
Excel spreadsheet comment boxes keep shrinking smaller than text. | Excel Worksheet Functions | |||
delete multiple "drop down" boxes in an excel spreadsheet | Excel Discussion (Misc queries) | |||
Multiple text boxes selection | Excel Worksheet Functions | |||
Embedded Excel Spreadsheet in MS Word Corrupted | Excel Worksheet Functions |