Display cell width & height

midann · Apr 17th, 2002, 03:27 PM

Two questions

1. Is there a way to have a cell's width and height displayed all the time? I know you can find what it is from Format-Row-Height and Format-Column-Width.

2. Is there a way to "hold" a toolbar's settings once you have customized it?

Thanks for the help.

Ann

Jay Petrulis · Apr 17th, 2002, 03:32 PM

Quote:

On 2002-04-17 14:27, midann wrote:
Two questions

1. Is there a way to have a cell's width and height displayed all the time? I know you can find what it is from Format-Row-Height and Format-Column-Width.

2. Is there a way to "hold" a toolbar's settings once you have customized it?

Thanks for the help.

Ann

Hi Ann,

1. These properties can be captured, so I am sure someone can take this and put it in an event macro for you. I believe this would require VBA, possibly a toolbar button where the .caption property changes on the event macro.

If I find some time, I'll give it a try.
------------------
Sub test()
MsgBox ActiveCell.Height
MsgBox ActiveCell.Width

MsgBox Range("A1:A20").Height
MsgBox Range("A1:B20").Width
End Sub
-----------------

2. Not sure what you mean.

HTH,
Jay

midann · Apr 17th, 2002, 03:56 PM

Jay,

Thanks for the tip on the buttons for cell width and height. For the second question,
I customized the standard and formatting toolbar by adding and deleting icons. This was done through View-Toolbars-Customize. Once finished customizing I went into the options tab and removed check marks from the first 2 boxes. I don't want the toolbars to change once I've customized them. Thanks again. Ann

Chris Davison · Apr 17th, 2002, 04:16 PM

Ann,

the tools option is workbook-specific as far as I know....

saving your toolbar settings though they are in a file with an extension .xlb

(sorry to be vague but I've had a few problems trying to save these)

1) search this board for any occurances of ".xlb" to give you a bit of info

2) search your hard drive for any .xlb files and save them all somewhere safe. If you lose your toolbar settings you can then reinstall these saved ones.

I think Dreamboat mentioned that they are often prefixed with your user-id if you're runnign Excel over a network so you may see an "ann8.xlb" or something similar.

that about the limit of my poor knowledge on these damn things - I have to reinstall just about once a month cos of various crashes / reimaging etc etc grrrrr

_________________
Hope this helps,
Chris

marker

[ This Message was edited by: Chris Davison on 2002-04-17 15:17 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 03:27 PM	#1
midann New Member Join Date: Apr 2002 Posts: 18	Two questions 1. Is there a way to have a cell's width and height displayed all the time? I know you can find what it is from Format-Row-Height and Format-Column-Width. 2. Is there a way to "hold" a toolbar's settings once you have customized it? Thanks for the help. Ann

Apr 17th, 2002, 03:56 PM	#3
midann New Member Join Date: Apr 2002 Posts: 18	Jay, Thanks for the tip on the buttons for cell width and height. For the second question, I customized the standard and formatting toolbar by adding and deleting icons. This was done through View-Toolbars-Customize. Once finished customizing I went into the options tab and removed check marks from the first 2 boxes. I don't want the toolbars to change once I've customized them. Thanks again. Ann

Apr 17th, 2002, 04:16 PM	#4
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Ann, the tools option is workbook-specific as far as I know.... saving your toolbar settings though they are in a file with an extension .xlb (sorry to be vague but I've had a few problems trying to save these) 1) search this board for any occurances of ".xlb" to give you a bit of info 2) search your hard drive for any .xlb files and save them all somewhere safe. If you lose your toolbar settings you can then reinstall these saved ones. I think Dreamboat mentioned that they are often prefixed with your user-id if you're runnign Excel over a network so you may see an "ann8.xlb" or something similar. that about the limit of my poor knowledge on these damn things - I have to reinstall just about once a month cos of various crashes / reimaging etc etc grrrrr _________________ Hope this helps, Chris marker [ This Message was edited by: Chris Davison on 2002-04-17 15:17 ]