Textbox size changes on deletion of rows

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,


0
jmay (696)
10/3/2004 2:08:30 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
471 Views

Similar Articles

[PageSpeed] 50

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

Jim May wrote:
> 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?

-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

0
dsd1 (5911)
10/3/2004 2:22:54 PM
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

"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:41600B3E.5060207@contexturesXSPAM.com...
> 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
>
> Jim May wrote:
> > 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?
>
> -- 
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>


0
jmay (696)
10/3/2004 2:44:16 PM
Reply:

Similar Artilces:

Help
I have a calender item that I deleted. Now whenever I open Outlook (I have Office 2003), I get a reminder that the item is past due. When I click "dismiss" I get a message: "Cannot turn off Reminder. You may be reminded again. Could not complete the operation. One or more parameter values are not valid". How can I get rid of this, so I don't get reminded every time I start Outlook? Thanks for any help. Tom_0127 <tom_0127_nospam@yahoo.com> wrote: > I have a calender item that I deleted. Now whenever I open Outlook > (I have Office 2003), I get...

Hide rows with value "Hours"
I would like to toggle rows to hide/unhide based on the value "Hours" in column B. I think filtering is an issue to some blank seperator rows and merged cell headings. There are no merged cells involving Column B. Thanks. Public Sub ProcessData() Const TEST_COLUMN As String = "B" '<=== change to suit Dim i As Long Dim iLastRow As Long With ActiveSheet iLastRow = .Cells(.Rows.Count, TEST_COLUMN).End(xlUp).row For i = 1 To iLastRow .Rows(i).Hidden = .Cells(i, TEST_COLUMN).Value = "Hours" Next i End With ...

Changing Front End Back End Connection Through VBA
Hi, In a form in the front-end the location of the backend is mentioned. (this is the result of a dlookup from a table that holds the locations of all backends; user chooses which backend to connect to) How can I define that when the user clicks a connect button, all the tables in the front end are connected to the back end which is chosen? Thnx for your help! hi Rishi, On 04.02.2010 12:12, Rishi wrote: > How can I define that when the user clicks a connect button, all the tables > in the front end are connected to the back end which is chosen? http://www.mvps.o...

Book1 changes itself?
I have used XL97 on Windows 2000 for a long time. Just lately, XL has changed its behaviour, and I can't work out why. There are 2 problems, but they didn't start at the same time. 1. If I open XL and then immediately close it again, without doing anything, it asks me do I want to save the changes to Book1? What changes to Book1? 2. Whenever I start XL, re-calculation is set to manual. This is true even if I finish the previous session by re-setting the previous spreadsheet to automatic re-calculation and saving it. I tried saving different versions of Book1.xlt and in the end I del...

changing default language
I have the French version of office x, but my French is not as good as my English. I have a difficult time reading some of the options such as file, edit, view, etc. I was hoping there was some way to change the language to English. I don't know if this would mean changing some setting or uninstalling and reinstalling. Please help me. Thanks. In article 37b5ebd9.0410201526.7b053dd@posting.google.com, Brian Blanchette at bblanchette@cox.net wrote on 10/20/04 16:26: > I have the French version of office x, but my French is not as good as > my English. I have a difficult time readi...

I want to change a "No" to a "Yes" i
I have a work sheet that if on page 2 the cell says No, then on page 1 it says Yes and if on page 2 the cell is Yes then on page 1 it is No? What formula do I use, and how do I cereat it without getting a circle error? You need to define, "the cell". Which / Worksheet / cell(s), specifically? You also need to define, "it". Which Worksheets / cell(s), specifically, do you mean by this? "Circuitman57" wrote: > I have a work sheet that if on page 2 the cell says No, then on page 1 it > says Yes and if on page 2 the cell is Yes then on pa...

How change dimensions of data label text box in pie chart?
In Excel 2003, I can't seem to re-shape the data labels text boxes in my pie chart. I can change the font and allignment of the text within the text box. But, if the text defaults onto two or three lines, I cannot stretch the text box out to get the text to stay on one line. Normally, you can pull on the the little handles on the text box. Is there a trick to this that I don't know about? This is a deficiency in Excel's charting capabilities. The text elements seem like regular text boxes, but you are unable to resize or reshape them. Even VBA can't do this. The workar...

Cannot delete an email from inbox
Hi there, I'm using Outlook 2000SR2 on a machine running NT4 and have a problem with it. I cant delete this one e-mail and even when i click on it (right and left) and the preview pane is not being used, it freezes the whole system and has to be rebooted. Any ideas on how to get rid of this annoyance? Thanks in advance Andy ...

Best way to delete e-mails
Imagine user has mailbox at 230MB. User wants to delete all e-mails. She uses webmail only (she works remotely, no Outlook applications installed). What is the best way to delete her e-mails? As far as I can tell Outlook webmail makes people highlight maximum of 14 items and hit the delete button. Should I just delete her mailbox in Exchange and recreate it ? you could use exmerge in "archive" mode to empty it out... -- Susan Conkey [MVP] "Marlon Brown" <MarlonBrown@discussions.microsoft.com> wrote in message news:eD5cwjXSHHA.4956@TK2MSFTNGP04.phx.gbl......

Data was deleted and saved by mistake..need to go back
I need to go back to the data before it was saved, can anyone help Richard don't get your hopes up. Unless you have a copy or a backup ... it's gone. Regards Trevor "Richard" <anonymous@discussions.microsoft.com> wrote in message news:1084801c3bea6$222d5270$a601280a@phx.gbl... > I need to go back to the data before it was saved, can > anyone help ...

Best way to add a row to a table with calculations?
Suppose I have a worksheet like this: 1 2 Date Days 3 5/25/08 35 4 4/20/08 45 5 3/06/08 46 6 1/20/08 41 ... The value in the Date column is calculated (=A3-A4). I would like to add a row between rows 2 and 3 and have it acquire all of the properties of row 3. The best procedure I could come up with is: 1. Right click on row 3, select Insert. This inserts a row between 2 and 3, but it acquires the properties of row 2. 2. Select row 4 (old row 3) and press Ctrl-C (copy). 3. Select row 3 (new row) and press Ctrl-V (paste). This seems to work. Is there a better wa...

CultureInfo changed on Callback threads?
Basic scenario -Winforms client calling an asp.net web service on Windows X Problem: When I perform an async web service call from a winform client, my Thread.CurrentCulture and Thread.CurrentUICulture are changed from the initiating thread's culture Some code Set all the Cultures to a different culture static void Main() Thread.CurrentThread.CurrentCulture = new CultureInfo("fi-FI") Thread.CurrentThread.CurrentUICulture = new CultureInfo("fi-FI") Application.CurrentCulture = new CultureInfo("fi-FI") Application.Run(new SomeForm()) Make an Async web...

Highlighting Rows #2
Hi Is there a way in which the row you are currently on in excel is highlighted in a different colour, and reverts back to original when user moves to a new row? Thanks right click sheet tab>view code>paste this>SAVE. You'll like it. 'McCurdy.Here is something inspired by Don Guillett. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim MyRng As Range Set MyRng = Target.EntireRow Application.EnableEvents = False On Error GoTo end1 Application.Cells.FormatConditions.Delete With MyRng .FormatConditions.Add Type:=xlExpression, Formula1:= _ "=R...

Article 327378
I am confused about the article http://support.microsoft.com/default.aspx?scid=kb;en-us;327378. After applying the changes mentioned in the article , how long will it take for the new mailbox limits to enforced? Which registry entry is the amount of time it will take for the changes to take effect? Thank-you Kevin At most it will take two hours. Every two hours Exchange refreshes it's cache of directory items. At that time it pulls down, among other things, all new mailbox limits. You can force this by restarting the Information Store. Teo -- Teo Heras MCSE, CCNA Blog: http...

how to delete newsgroup messages
How do I delete messages in a newsgroup in Entourage 2008? Currently when I right-click on a message, the "Delete Message" option is greyed out. Jamie On 12/7/09 5:53 AM, in article C74272F0.16C53%jkite@cisco.com, "Jamie Kite" <jkite@cisco.com> wrote: > How do I delete messages in a newsgroup in Entourage 2008? You can't delete any newsgroup message. They are on the server and older ones are deleted on a schedule after xx days. -- Diane Ross, Microsoft Mac MVP Entourage Help Page <http://www.entourage.mvps.org/> Entourage Hel...

how do I remove the separator line after deleting a footnote in w.
how do I remove the separator line at the bottom of a page after deleting a footnote in word 2007 Provided you deleted the footnote correctly (by deleting the reference mark in the document body), the separator should not still be there. The fact that it is suggests that there is some residue of the footnote remaining. At a minimum, display nonprinting characters so you can see what you're dealing with. You may need to search the document for ^f (footnote reference mark) to find where the elusive footnote is hiding. -- Suzanne S. Barnhill Microsoft MVP (Word) Words int...

Having trouble with extra rows at the bottom of the doc
How do I delete the extra rows at the bottom of a doc. I have inherited a document that has 60 rows of data and 3682 rows of empty cells that have the boarder set. When I select and delete them, new ones reappear. I have turned the cell boards off and it still creates empty cells with the boarder. Is there any way to delete these rows? -ken Ken, Are you selecting and then deleting and then saving? HTH, Andy Ken Excel has a habit of retaining "used" cells way beyond where you are currently working. On a worksheet hit CRTL + END to see where you wind up. If far below and...

Delete records when certain records have duplicate column data
Hi, I'm new to excel. I want to delete (sort of) duplicate records. My spreadsheet has many columns. My spreadsheet has many records I want to delete records where the data in just a few columns is the same in multiple records. (e.g. if the values in columns "A" "B" "D" "F" in any record is duplicated in multiple rows ..delete all matching records/rows. A= house number B= street name D=apt number F=city Bonus points: Can a macro/button be created that will allow me to load a spreadsheet and then somehow run the above filter/function on the ...

Word 2003: Possible to Use both Forms and Tracked Changes Protect
I've not been able to figure out a way to protect a document so that one section is protected for filling in forms only, and another section is protected in tracked changes mode. I want to create better contract templates for use by our sales teams (thus the forms protection - they can only fill in the gray fields and not alter other sections of the template), while allowing our clients to made modifications to the terms in the subsequent pages. I find Word protection features very limited. Hopefully it's better in 2007. Thank you. A document can only have one type ...

Rows in a report 02-12-10
I have a report with mulitple text boxes in the detail of the report. One of the text boxes has a number in it. I want the report to output that many rows on the report even if the other text boxes are blank. Any way to do this? Thanks in advance. Check out Allen Browne's page http://www.allenbrowne.com/ser-39.html. -- Duane Hookom Microsoft Access MVP "PJ" wrote: > I have a report with mulitple text boxes in the detail of the report. One of > the text boxes has a number in it. I want the report to output that many > rows on the report...

How do I change the default directory for Publisher 2003?
My c: drive was short on space after I upgraded to Office 2003 so I moved the clip art to a separate drive. No linking problems with Word, XP, etc - just Publisher where I really USE clip art! How can I tell Publisher that my clip art - and ALL pictures - are on a different drive? On Sun, 13 Nov 2005 21:25:03 +0000, The Kat wrote (in article <93A63632-5792-4B19-A2F5-99EE5260C3FB@microsoft.com>): > My c: drive was short on space after I upgraded to Office 2003 so I moved the > clip art to a separate drive. No linking problems with Word, XP, etc - just > Publisher where ...

How to change 'Address List Name' Property from a MailEnabled Public Folder?
I want to change the 'Address List Name' Property of my MailEnabled Public Folder from 'Same as folder name' to 'Use this name', but i found no Property or Method. http://www.microsoft.com/technet/prodtechnol/exchange/2000/maintain/ex2kwsh.mspx With the attached Script i can modify SMTP Adress and Alias, but not the Address List Name Entry for the Addressbook. Who can help? ' ------------ Dim strURLOpen Dim strURLItem Dim objMailRecipient Dim objConnection Dim objRecord Dim objFolder Const adModeReadWrite = 3 Const adOpenIfExists = &H2000000 Const adCreateC...

Options for Accept Changes -- 2007
I'm a newbie in Word 2007 (just changed over from 2003 on Monday). So far, I'm not impressed. (Okay, I'm not favorably impressed.) On the review ribbon, the default option for the Accept check mark is "Accept and Move To Next." Is there any way to change that default to simply "Accept Change"? 99.9% of the time, I want to accept a change AND STAY RIGHT WHERE I AM. I don't want to jump several pages and then try to figure out where I was. While I'm at it, Shift-F5 doesn't seem to work to take me back to where I was. Is there another ...

Copy above row data into blank fields below
Hi. Certain fields within my data do not repeat, but I'm trying to find a way to populate the blank cells from the preceding row. Here's an example: Employee_Number Last_Name First_Name 123456 Smith John Judy Ben 123457 Johnson Bill Ruth Eddy Sally As you can see, it didn't repeat the Employee Number ...

Is there a way in Exchange 2000 to export a list of all the mailboxes over a certain size?
Is there a way in Exchange 2000 to export a list of all the mailboxes over a certain size? At the moment I am just going in Exchange System Manager and then trawling through all the storage groups to check the numbers. It is kind of laborious to check the size of mailboxes and the number of messages one at a time, so was wondering if there is a way to do this automatically within Exchange, or do I need to use third party tools? Thanks, QH This is possible if you have Crystal. There is a 3rd party, will have a poke around now Yes it is possible to get a list of mailboxes over a certain s...