View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charles Williams
 
Posts: n/a
Default Excel 12, er, 2007 - Semi-idle Curiosity

Hi Harlan,

I know there has been some discussion of this amongst Access people, but I
dont know the outcome.
You certainly cannot do it using the commandbars model, you would have to
use the XML stuff, and I have not looked at that in enough detail to know
the answer.

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"Harlan Grove" wrote in message
oups.com...
Harlan Grove wrote...
...
Or do the NDAs prevent you from saying?


Since the NDAs don't prevent discussing how the public beta actually
works, another question. When the UI gets in the way, it's nice to get
rid of it COMPLETELY. Does XL12 support the equivalent of the following
(**WARNING** USE IN A **SECOND** EXCEL INSTANCE) in older versions?


Sub ugh()
Dim x As CommandBar
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = False
For Each x In Application.CommandBars
x.Enabled = False
Next x
End Sub


This leaves only the row/column frame and the worksheet tabs, if they
were already visible. I've read in the blog that the ribbon can be
colapsed to just its tabs, but can it be COMPLETELY HIDDEN/DISABLED?

FWIW, Excel history buffs will recall that XL5 had a brand new menu
compared to XL4, *and* Microsoft provided an option in XL5 that
REPLACED the new XL5 menu with the XL4 menu. [Microsoft failed to
provide an option in the XL4 menu that switched back to the XL5 menu,
making for much joy using the product.] Is there an equivalent feature
for XL12? Or is this New Coke before Coca Cola Co realized the revenue
potential of also [also?! - do they still make New Coke?] selling
Classic Coke?