How to expand the formula bar when excel opens

  • Thread starter Thread starter Jeff Lowenstein
  • Start date Start date
J

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?
 
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?
 
hi
The formula bar expands automaticly as needed. why do you want to expand it
and how would this expantion be? wider?

regards
FSt1
 
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

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
 
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
 
Thank you. I have someone that wants it to start out in the expanded version
all the time.
 
Back
Top