How to expand the formula bar when excel opens

[Jeff Lowenstein]

I would like to expand(maximize) the formula bar everytime excel starts. I
would guess that I need to use a macro to do this. My question is how do I
tell my personal workbook to automatically run this macro?

 

[Jeff Lowenstein]

I found out how to create the Auto_Open macro, but do not know how to
automate the formula bar expansion in a macro. Can that be done, and if so,
how?

 

[FSt1]

hi
The formula bar expands automaticly as needed. why do you want to expand it
and how would this expantion be? wider?

regards
FSt1

 

[Dana DeLouis]

I would like to expand(maximize) the formula bar everytime excel starts

This feature was added in Excel 2007

Application.FormulaBarHeight = 4

The "Maximum" value I can set on my Computer is 27.

 

[FSt1]

thank you. i'm still stuck on 2003. I learn more about 2007 each day.

regards
FSt1

 

[Gord Dibben]

FSt1

One of these day I will install just so's I can see what all those 2007 folks
are talking about.

I've got VPC 2007 and Office 2007 Ultimate but too much work<g>


Gord Dibben MS Excel MVP

 

[Roger Govier]

nah, what you really mean Gord is that it would impinge too much upon the
golf<bg>

 

[Roger Govier]

Hi Jeff
In XL2007, if you just need it bigger (as opposed to maximised) the shortcut
Control+Shift+U is a toggle between a single row depth and 4 row depth

 

[Gord Dibben]

I think your driving accuracy is 100%


Gord

 

[Jeff Lowenstein]

Thank you. I have someone that wants it to start out in the expanded version
all the time.