Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to be able to toggle a Tab visible/hidden on the Ribbon based upon the
contents of a cell. I have the tab written in XML and the following call back works, but only each time the file is closed and reopened. How can I make this more fluid so it updates immediately without having to close and reopen the file? Is there a way I can call the Callback below to make it run again? Sub getVisibleCallback(control As IRibbonControl, ByRef visible As Variant) Dim sShow As String sShow = [A1].FormulaR1C1 If UCase(sShow) < "" Then visible = True Else visible = False End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Visible Sheet Showing When Hidden | Excel Programming | |||
Toggle text to be visible and not visible | Excel Programming | |||
Toggle Text to be visible and Not visible | Excel Programming | |||
Toggle Text in a column to be visible or not visible | Excel Programming | |||
Check status row (hidden or visible)? | Excel Programming |