Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
JelteDeJong
in reply to: WCrihfield

i could not find a way to set the default filters but you could create your own filter. The following i logic code will filter all rows that have the letter "e" in the 3e cell. (that is ofcource not usefull but maby a start point for your own filter)

Dim doc As DrawingDocument = ThisApplication.ActiveDocument
Dim sheet As Sheet = doc.ActiveSheet
For Each row As PartsListRow In sheet.PartsLists.Item(1).PartsListRows
    Dim cell As PartsListCell = row.Item(3)
    If (cell.Value.Contains("e")) Then
        row.Visible = False
    Else
        row.Visible = True
    End If
Next

Jelte de Jong
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature


Blog: hjalte.nl - github.com