Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Display cell width & height

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •