Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    User Control of the Formula Bar (XL 2003)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers

    Is there any user control over the Formula Bar so that when a cell contains a long formula or long text the "window" will not expand and cover the column headers and any top rows?

    I know you can hide the cells and protect the worksheet but we still need to work with the cells, so this is not s true option.

    Any ideas?

    Thanks a <img src=/S/money.gif border=0 alt=money width=17 height=15>

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User Control of the Formula Bar (XL 2003)

    There is no way to change that behavior as far as I know.
    Legare Coleman

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: User Control of the Formula Bar (XL 2003)

    I agree with Legare - that is not possible.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: User Control of the Formula Bar (XL 2003)

    Since you don't want to hide the formulas and protect the sheet, you could hide the formula bar (View , uncheck "Formula bar") and this will still allow editing the of the cells but will not have the formula bar covering the other cells.

    Steve

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: User Control of the Formula Bar (XL 2003)

    <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> Steve, Hans and Legare

    After I posted the message I figured out Steve's suggestion. It works for my purposes, and when the user will interact with the application later on, well tough.

    Some times you have to amputate the limb for the comfort of the rest of the body.

    Cordially

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  6. #6
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: User Control of the Formula Bar (XL 2003)

    Hi Wassim
    I use the following code fired by a keyboard shortcut. <pre>Sub Toggle_F_Bar()
    Application.DisplayFormulaBar = Not Application.DisplayFormulaBar
    End Sub
    </pre>

    HTH
    Regards
    Don

Posting Permissions

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