Display cell width & height

[midann]

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]

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]

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]

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 **** 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