 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008How to expand the formula bar when excel opens
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? > 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 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.  SignatureHTH :>) Dana DeLouis Windows XP & Excel 2007 >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 [quoted text clipped - 6 lines] >> I >> tell my personal workbook to automatically run this macro? thank you. i'm still stuck on 2003. I learn more about 2007 each day. regards FSt1 > >> I would like to expand(maximize) the formula bar everytime excel starts > [quoted text clipped - 13 lines] > >> I > >> tell my personal workbook to automatically run this macro? 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 >thank you. i'm still stuck on 2003. I learn more about 2007 each day. > [quoted text clipped - 18 lines] >> >> I >> >> tell my personal workbook to automatically run this macro? nah, what you really mean Gord is that it would impinge too much upon the golf<bg> SignatureRegards Roger Govier > FSt1 > [quoted text clipped - 32 lines] >>> >> I >>> >> tell my personal workbook to automatically run this macro? I think your driving accuracy is 100% Gord >nah, what you really mean Gord is that it would impinge too much upon the >golf<bg> 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. 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? 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 SignatureRegards Roger Govier > 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? Thank you. I have someone that wants it to start out in the expanded version all the time. > Hi Jeff > In XL2007, if you just need it bigger (as opposed to maximised) the shortcut [quoted text clipped - 5 lines] > > I > > tell my personal workbook to automatically run this macro? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.