View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Programmatically determine if a control is .VISIBLE or not.

I am surprised no-one gave you a response to such a simple question, but
looking back at it I see your original post mentioned 'Refresh All'. That
may be why.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

<Toby Erkson wrote in message
...
Well, good to see that I can stump some people :-)

Talked with a friend who's a VBA demi-god and here's what we got:
------------------------------------
...
Visible = isVisible("Refresh Data") 'Example of use
If Visible Then...
...

Function isVisible(sButton As String) As Boolean

On Error GoTo ErrorHandler
isVisible =

Application.CommandBars("PivotTable").Controls(sBu tton).Visible
Exit Function

ErrorHandler:
isVisible = False
Exit Function
End Function
------------------------------------

Toby Erkson
Oregon, USA