Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alternate to Sheet_Calc when Filter applied.
Hi All
I'm using the Worksheet_Calculate event to show/hide 2 images on the active sheet when a filter is applied. The issue is that the event fires whether I'm on the sheet or not. My question then is: Is there an alternate way I can show/hide the images without using the Worksheet_Calculate event when a filter is applied? Code below Thanks in advance Trevor Willams 'Worksheet module Private Sub Worksheet_Calculate() Call ShowClearFilterButton End Sub 'Code Module Sub ShowClearFilterButton() With ActiveSheet On Error Resume Next If .AutoFilterMode = True Then If .FilterMode = True Then .Shapes("picFilter").Visible = msoTrue .Shapes("btnFilter").Visible = msoTrue Else .Shapes("picFilter").Visible = msoFalse .Shapes("btnFilter").Visible = msoFalse End If End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
Re-calculate sum after filter is applied. | Excel Programming | |||
Refresh with Advance Filter Applied | Excel Discussion (Misc queries) | |||
FILTER applied to many coloumns | Excel Discussion (Misc queries) | |||
how do i identify first and last row once filter applied | Excel Programming |