View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
deanop deanop is offline
external usenet poster
 
Posts: 9
Default chk box to filter or hide rows based on value in a column

Thanks Dave for the feedback......I added the propsed code and assigned
to a new forms control chk box.

When the box is checked, the code adds filter drop downs but does not
proceed to filter out the rows.
When the box is unchecked, the code excecution is interrupted because
the .ShowAll Data method fails
Any thoughts on how to overcome.....

Thx, Deano