Textbox size changes on deletion of rows

J

Jim May

I've created a textbox (using the Drawing Toolbar).
The textbox extends downward and actually to the right-hand side of 15 rows
of data.
I run a macro that deletes 5 or 6 rows and my textbox shrinks because of the
deleted rows; how can I prevent this from happening?
TIA,
 
D

Debra Dalgleish

Set the properties of the text box so it doesn't size with the cells:

Select the text box
Choose Format>Text Box
Select the Properties tab
Select Move but don't size with cells
(or -- Don't move or size with cells)
Click OK
 
J

Jim May

Thanks Debra;
I had clicked once inside the text box then right-clicked thereby getting
only the single Font Tab; It's important to know to click on the "border"
first then right click; both show "format textbox", but only going via the
border do you get the more potent 5 or 6 tab choice, which of course
includes the Properties tab (which is what I was looking for in the first
place...
Thanks again (perhaps now I can remember for the next time i need to do this
(in six months, LOL)...
Have a great Day,
Jim
 
Top