ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I set the default for task bar in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/264852-how-do-i-set-default-task-bar-excel.html)

DoctorG

How do I set the default for task bar in Excel
 
Click on View and check task bar and it appears but disappears when I open
Excel again.

Tamer Paksoy

How do I set the default for task bar in Excel
 
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" wrote:

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


bala_vb

Quote:

Originally Posted by DoctorG (Post 956968)
Click on View and check task bar and it appears but disappears when I 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 function does
nothing).

Public Function ShowReportRibbon()

Dim intRibbonState As Variant

intRibbonState = fReturnRegKeyValue(HKEY_CURRENT_USER, _
"Software\Microsoft\Office\12.0\Common\Toolbar s\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\Toolbar s\Ac cess", _
"QuickAccessToolbarStyle")

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

End Function

all the best


All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com