Have you tried the macro recorder? Then reference the code in the ViewCode
right-click option of your button.


--
HTH
Roger
Shaftesbury (UK)


"Stevie" wrote in message
...
Hi guys, I'm a novice excel user, but have the following
query in Excel 2000.

I have a spreadsheet that contains numerous rows and on
each row I have applied an auto filter.

I have a button that I want to attach a macro that will
automatically apply a filter to the data. Does anyone
have any ideas?

Many thanks.