Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Click on View and check task bar and it appears but disappears when I open
Excel again. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#3
![]() |
|||
|
|||
![]() Quote:
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
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - task pane | Excel Discussion (Misc queries) | |||
Scheduling task for Excel | Excel Worksheet Functions | |||
Excel Task Pane | Excel Discussion (Misc queries) | |||
Scheduling a Task to run Excel | Excel Discussion (Misc queries) | |||
Multiple Excel on Task bar | Excel Discussion (Misc queries) |