How do I set the default for task bar in Excel

  • Thread starter Thread starter DoctorG
  • Start date Start date
Hi DoctorG,
I assume you use Office 2007 and sounds like ribbon is minimised. Right
click on menu bar and tick-off "Minimise the Ribbon".
 
DoctorG;956968 said:
Click on View and check task bar and it appears but disappears when
open
Excel again.
Click to expand...

if you are familar with VBA try this

I have two functions, one to hide, and one to show.

(and, if the ribbion is already hidden (or showen), then the functio
does
nothing).

Public Function ShowReportRibbon()

Dim intRibbonState As Variant

intRibbonState = fReturnRegKeyValue(HKEY_CURRENT_USER, _
"Software\Microsoft\Office\12.0\Common\Toolbars\Ac cess", _
"QuickAccessToolbarStyle")

If intRibbonState = 4 Then
' ribbon in auto hide state, show it...
SendKeys "^{F1}", False
DoEvents
End If

End Function

Public Function HideReportRibbon()

Dim intRibbonState As Variant

intRibbonState = fReturnRegKeyValue(HKEY_CURRENT_USER, _
"Software\Microsoft\Office\12.0\Common\Toolbars\Ac cess", _
"QuickAccessToolbarStyle")

If intRibbonState = 0 Then
' ribbon is in full view....hide it...
SendKeys "^{F1}", False
DoEvents
End If

End Function

all the bes
 
Back
Top