Hi E

If you protect your sheet with your filter on you have a few options that you can check and one of them is Filtering
if your Excel version is not to old.

See
http://www.contextures.com/xlautofilter03.html#Protect




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"E" wrote in message ...
I have just put my first macro in a sheet as a button which filters certain
row. I want to protect the majority of the sheet so that when I send it out
users can can only amend some cells, but be able to use the filter. When I
protect and click my macro button, it tells me I cannot do this with sheet
protection on.
I really want to use the protection as my users are liable to break pretty
spreadsheets, so can you think of a way I can both protect and use my filter
macro?
Thanks.