How do I set the default for task bar in Excel

D

DoctorG

Click on View and check task bar and it appears but disappears when I open
Excel again.
 
T

Tamer Paksoy

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".
 
B

bala_vb

DoctorG;956968 said:
Click on View and check task bar and it appears but disappears when
open
Excel again.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top