Hi everybody,
I have a question regarding auto filter usage. I have a sheet/table
which has a table calculating certain values regarding certain other
values manually typed in by third persons.
In order to protect the formulas I have locked the cells but now I
would like to filter out all the rows which are blank in this table in
order to keep just the rows which in the print version are important
to be displayed.
Is that possible, or since the cells are locker nothing can be
filtered?
Best regards,
Jan
Ron de Bruin - 08 Dec 2004 15:09 GMT
Hi JFL
Look here
http://www.contextures.com/xlautofilter03.html#Protect

Signature
Regards Ron de Bruin
http://www.rondebruin.nl
> Hi everybody,
>
[quoted text clipped - 13 lines]
>
> Jan