Annoying grey bar on the left of the screen

Re: Annoyning grey bar on the left of the screen

Is this when a macro is run? Similar problem here http://www.mrexcel.com/forum/showthread.php?t=302010 but no real solution I'm afraid.

Re: Annoyning grey bar on the left of the screen

To Vog II,

I am really enjoying your formula for hiding the "#DIV/0" error message in cells yet to be popullated w/numbers.

Q: Conversion Trivia Vog II: Excel's `ADD-IN-TOOL PAK' Stinks. Mostly I utilize 'Machinery Handbook' in the U.S.. An obscure conversion formula occurred to me; I like the late 80's Ray Davies (formerly of The Kink's) tune of SUPERMAN STUCK into my head.
"... a 9 Stone weakling looking back at me....".

Persistance prevailed & now I know that 1 Stone = 14 U.S. Pounds. As well as, 1 DOANE = 5.82 oz.

Website: metric-conversions.org

Many Thanks Again, for hiding #DIV/0

"... onward, through the fog...." - Ted Roesch

Hi Ted

The Analysis ToolPack does do some conversions - in fact a full list is available under the topic Convert in this excellent little download http://www.xlfdic.com/

One has to be careful - for example in converting litres to gallons it uses Queen Anne (US) gallons = 3.85 litres whereas in the UK we use Imperial (king/queen, who knows or cares) gallons which are ~4.54 litres (or liters if you are American).

This isn't an idle observation. In my line of work I have to convert flowrates through a filter expressed in gallons per square foot per minute into units that Europeans understand (metres per second). I use a calculator, not Excel.

Thank You VoG II,

When all esle fails, " hit the books". - Some body has already thought of it.

- Ted Roesch

dafreedomfita said:

does anyone know why this bar on the left keeps appearing, and what can be done about it? thanks

Click to expand...

I have had a similar problem with my code (which calls Solver several times in succession). The problem began quite randomly, as the macro that causes the grey bar was not edited around the time the error began occuring.

I have found a workaround:

Application.CommandBars("Task Pane").Visible = True
Application.CommandBars("Task Pane").Position = msoBarLeft
Application.CommandBars("Task Pane").Visible = False

Executing this code is essentially macroing the manual fix of opening a task pane and docking on the left side, forcing a 'refresh' of this portion of the application window.

Obviously, this only fixes the symptom not the problem, but at least it prevents the issue from affecting the user.

the annoying grey bar is actually part of your tool bars. Why it shows up is anyones guess, but to make it go away, put a tool bar over then and then a) move it back to the top, or b) hide it.