james,

Put a button from the forms toolbar on your sheet and assign this macro to
it:

Sub toggle_filter()
With ActiveSheet
If .FilterMode = True Then
Range("E:E").AutoFilter
Else
.Range("E:E").AutoFilter field:=1, Criteria1:="<"
End If
End With
End Sub

hth,

Doug


"james" wrote in message
...
Okay. So, at one point in time I used a spreadsheet that had a buttton
built
into the spreadsheet that made all rows with no data in column e
dissappear.
I am an idiot but i need to do this to my order forms. Then it had
another
button that made it reappear.