Free Microsoft Excel 2013 Quick Reference

lock shape size


I need add 2 shapes to a sheet. The user copy and paste the shapes in to a cells to show a product is complete or still in process. Some users change me the sizes of this shapes by error, can i lock the size of a shape but still give me way move,copy and paste the shape.


Post your answer or comment

comments powered by Disqus
i need to lock font sizing in a shared worksheet. How can I so other bone heads dont change it on me?

I have a number of column charts in a worksheet which is updated each
day with the charts copied into Photoshop Elements before being loaded
onto my website.

Unfortunately, the chart sizes 'drift' over time even though I keep
resetting them to the exact number of pixels in width and height that I
require for the website. Is there a way to specify and then lock the
size in pixels? There are too many charts to adjust each one each day
and I do not want browsers to have to resize them when the page is viewed.



Hi, I was wondering if it's possible to lock the cell size in an .xls

I'm currently entering written information into the cells. However, when I click on to a different cell, the previous cell's row height automatically readjusts to accomodate all the written information and so I end up with a row height of 400 as opposed to the standard 12.75.

Is there any way I can just enter the data and then click on another cell without the format cell size being changed?



I have a series of line charts (time-x vs value-y) with axis limits and
data ranges updated automatically. I need to come up with a way to
identify certain periods of time with shading. But I don't wish to
simply draw rectangles because I don't want to have to edit the
location of the shapes every time new data is added. Also, I have
about 30 charts to create and maintain.

So ...

1. Is there a away to associate shape position/size to axis values?

2. If not, are there other charting options that would allow me to
plot time vs value overlayed by bars/columns with widths and locations
dictated by the same time-x axis? In other words, I need the location
and width of the columns to be determined by x axis data.

Thanks in advance!

William DeLeo
William DeLeo's Profile:
View this thread:

I am trying to present an analysis that I want to lock the column size for
several rows. Below the analysis, I want to present another analysis that has
different column sizes. Is it possible to lock the column size for the one
presentation and then resize them for the other without changing the original

I want to size a shape based upon the text contained with the shape...and do this via Excel 2007 VBA.

Say I have a rectangle shape that is 40 pixels wide and 40 pixels high with a single line of text inside of it that would go beyond the end of the shape. I want to resize the height of the shape to accomodate the all the text. Say maybe the new rectangle might be 80 pixel high by 40 pixel wide.


I have a series of line charts (time-x vs value-y) with axis limits and data ranges updated automatically. I need to come up with a way to identify certain periods of time with shading. But I don't wish to simply draw rectangles because I don't want to have to edit the location of the shapes every time new data is added. Also, I have about 30 charts to create and maintain.

So ...

1. Is there a away to associate shape position/size to axis values?

2. If not, are there other charting options that would allow me to plot time vs value overlayed by bars/columns with widths and locations dictated by the same time-x axis? In other words, I need the location and width of the columns to be determined by x axis data.

Thanks in advance!

Hi everyone,

I've been wrestling with what is probably a simple problem. I have a map of the US on one worksheet with shapes (circles) over locations where our company has resources. I've put in a button on that sheet that toggles the shape on or off using the .visible = true or .visible = false properties. This button also has a caption that toggles as well. However, I also want to dictate the size of those shapes based on values entered in another worksheet in the same workbook. I've tried and just can't get it to work. Here's the kind of code I am using to toggle the visibility. I'd like to insert code into this event that will also adjust the circle size based on value in a cell. Thanks!

Sub CommandButton5_Click()
If CommandButton5.Caption = "Hide" Then
CommandButton5.Caption = "Show"
ActiveSheet.Shapes("Oval 1_LosAngeles").Visible = False
If CommandButton5.Caption = "Show" Then
CommandButton5.Caption = "Hide"
ActiveSheet.Shapes("Oval 1_LosAngeles").Visible = True
End If
End If
End Sub

I am in need of a solution for Office 2008 Mac, Excel, I am trying to figure out a way to get Excel to lock the cell size so that when it is viewed in older versions of Excel the cell sizes remain the same as when I create them. Kind of like a PDF, but where it can be saved on older operating system, PC.


I have a listbox on a worksheet which is linked to a named range, the named range is a results from a database query. Now the problem I have is everytime the query is refreshed the listbox expands in size. Is there anyway to stop the listbox from growing thus 'locking' the size ??

It seems very straignt forward, I'm I missing something ???

Hi all,

I'm trying to make a circles size (diameter) change depending on a value inputted in a cell, preferable I would like to have a limit to the sizes too so if that the circle will not have a diameter larger than 20 or smaller than 2 regardless of the values put in. the sheet will have several circles.

I know this must be documented somewhere but I don’t think I’m using the right terminology in my searches, any information would be helpful.


This sounds simple but I cannot figure it out.
I created a shape (rectangle). I assigned a macro to it, to activate another worksheet.

Can I fix the position of the shape on the screen, near the top. I have 700 rows in the worksheet and I want this rectangle always visible, near the top.

Thanks in advance,


Is it possible to program the width and height of an object added onto a chart?

To position a range I can use:
selection.shaperange.left = value = value

But, if I want to change the proportions of the actual shape (not the shape range), is it possible? selection.shaperange.width/height do not seem to work.


There is something strange with a spreadsheet, which contain many charts (all represent different temperature sensors).
I've made a macro to change at once time the X-Axis range (=time axis) on all charts.

The 1st time it works without any problem but if I want to change a second time the range, then many charts will be also reduced (only the chart inside the chart frame is reduced), although the macro act only on the values of the axis (... .Axes(xlCategory).MinimumScale = ...)
Have anyone any ideas why this happen. Is there any possibility to lock the size of my chart in order that when I change something in the axis it changes only what I want?


I use Excel spreadsheets to gather prerequiste information from my clients
before we install software at their site. The comments are very important to
the clients because they explain what is needed in each cell. The trouble
is, these comment boxes seem to resize themselves at will, and you have to
enlarge them before you can read the contents. Sometimes they become just a
vertical line. I'm always apologizing to my clients for this 'feature' in
Excel. Is there a way to lock the size and location of a comment box in a
worksheet? If not, consider this an enhancement request.

This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

I am using an Excel worksheet to track e-mail addresses. I want the font size to be 8. However, every time I click on an e-mail address the font size changes to 10. How can I format the cells so the font size for e-mail addresses always stays at 8?

I am currently creating pivot tables with the only variable being a boolean variable (values either 0 or 1). Sometimes in my dataset (from an external data source created by SPSS) there are either no 0s, no 1s or no data at all. When this occurs my pivot table doesn't provide a column for the missing value(s).

My question is, how can I create a pivot table that will always show the 0 and 1 columns even if no data is present for those values? I need this because I have another excel spreadsheet reading from the table and I don't want to have to update where the spreadsheet is pointing every time the pivot table changes shape/size.

Thanks for any help provided.


I'm having trouble finding information on how to lock cell size, width, and colour while allowing users to still edit cells in Excel 2003.

Basically, we use an excel spreadsheet to keep track of advertising sales at the small newspaper I work at. We have a pre-formatted worksheet for each week that is colour coded to make it easy to print and read. The problem is that three people access it during a given week to enter the various info related to their job. By the time it gets to me at the end of the week, a plethora of cut-and pasting (that changes the colour) and changing of cell sizes makes the spreadsheet difficult to read and time consuming to re-format. All the cells start out the right size and colour, is there a way to lock the spreadsheet so that this can't be changed while still allowing users to enter their info as text?

Any help would be appreciated.

Would any know of way/website that could provide instructions in creating a map like this one, For other reasons I cannot use tableau software. I found instructions choropleth maps,; however, would prefer to use shape size for my data indicator over color.


I have a workbook named "IPR" and on that i have 12 sheets named "Jan" for the month of January,Feb for the month of Feb and so on, Then i have two sheets named "Snap-Shot" and "Data".All the sheets will be hidden whe the workbook is loaded Excep the if we are working in the month of January, The Sheet named Jan and Snap-Shot would be shown. what i am trying to do is to protect all the used ranges in the Jan sheet. so that nobody can ammend it later or may be next day.

[FONT=Courier New][SIZE=2]Sub protect_formulas2()[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]    Dim wks As Worksheet[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]    Dim wkbk As Workbook[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]    [/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]    Set wkbk = ActiveWorkbook[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]    For Each wks In wkbk.Worksheets[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]        wks.Unprotect Password:="budget"[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]        wks.Cells.Locked = False[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]        [/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]        On Error Resume Next[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]        wks.UsedRange.Locked = True[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]        On Error Goto 0[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]        [/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]        wks.Protect Password:="budget", AllowFormattingCells:=True, _[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]            AllowFormattingColumns:=True, AllowFormattingRows:=True, _[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]            AllowInsertingColumns:=True, AllowInsertingRows:=True[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]    Next wks[/SIZE][/FONT] 
[FONT=Courier New][SIZE=2]End Sub[/SIZE][/FONT] 

If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

i got this code from one of the forums,can somebody help to protect the sheet named after the Current Month

I was working on my latest project, and posted a question about cell comments etc etc.

This was answered by Jak and Ivan.

I was playing around with Ivan's solution (which can be found at :
but now I've suddenly found that I'm having problems with getting code to select cells, and that when a range is selected on a sheet, it remains selected, even if I go to another sheet, and select another range there. I'm not suggesting for one moment that Ivan's code was anything to do with it, I only mention it in order that it may help with diagnosing my problem.

The part of the code I had been playing with was towards the bottom, i.e. changing the font, and comment shape size.
Can't help thinking I've inadvertantly set up excel differently.
I've tried opening another workbook, and shutting down and re-starting, but to no avail.
I'm running windows 98, and excel 2000 premium.

Ta, hoping


....and the meek shall inherit the earth...
(but not the mineral rights!)

[ This Message was edited by: sykes on 2002-08-27 02:38 ]

When I copy and past a graph, excel resizes it. It does not matter if I say
move and size with cells or move and don't size with cells. I need to make
MANY graphs all of the same size. I created a custom layout, but I then must
manually resize every graph. Is there a way to copy and past as the same
size? Is there a way to LOCK this size as well?


I remember that a fancy and tidy solution to my problem exists - but I've
forgotten it. Can you help please?

All my named ranges here utilise offset formulas: they can change shape,
size and they can move.

I have a named range spanning multiple columns and rows. Now I want to run a
match formula on the 5th column of this named range. Rather than creating a
new named range, how can I tidily reference the 5th column of my existing
named range?

Also, I have another named range just covering 1 row. How, by referencing
this named range, can I pick out the value in the 7th column?

Thanks ever so much... I'll go and see if I can return a favour to somebody
else here =o)


Hello everyone.

Recently, Ive run into a little problem with Excel that I can't seem to solve myself. After hours upon hours of research, google-ing, HELP file reading, and general frustration...I absolutely can NOT find any way to disable the Autofit feature on microsoft excel.

My office 2003 system information is as follows, just in case this information is useful:
OS Name: Microsoft Windows XP Professional
Version: 5.1.2600 Service Pack 2 Build 2600

The reason I want to be able to turn this feature off is simple; I like to control the size of my cells manually. I have my entire workbook set to 20x20 pixels, such that the height and width of all cells is uniform. I like to import and export things between my workbooks, as well as from my friends' workbooks, so we all have no difficulties with sizing our data. But when the computer decides to autofit the text and change the widths of the columns, it skrews-up all my margins, my print areas, my borders, and generally makes everything look horrible. I understand the premise behind the whole concept. I know how to turn autofit ON, but I can't seem to lock the size of my cells. Even by changing the Standard Column Width, it still seems to alter the width whenever an error message like #DIV/0! or #NAME! pops-up.

Ultimately, I want to have control over how my document looks, and I can't have that with the sizes of my cells changing all the time. I tend to merge, unmerge, and combine cells as I need them. Autofit is not a feature that works well with my workbooks. Perhaps there is another possibility as to why the widths of my cells keep changing, but everything seems to point to this feature. I've managed to find an option which allows one to turn this off in Powerpoint, but not in Excel.

Could this problem be due to a virus, spyware, or malfunctioning Add-in of some kind? I haven't found anything malicious on my computer, and my add-ins work fine...or so it seems. But I could be wrong. If anyone has ANY ideas on how I can lock the widths of my cells, disable Autofit, add a VBA which can let me turn it off, or something else I'm not thinking of...please let me know. It might very well be an easy solution, but I think the aggrevation of this process has blinded me to any quick-fixes. I'm perfectly willing to entertain anything at this point.

Thank you for any information you may have, as well as recommendations on where I might go or who I can ask to find an answer.

Most sincerely,

No luck finding an answer? You could always try Google.