ExcelBanter - Excel 2000 how to use filters in protected workbook

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Excel 2000 how to use filters in protected workbook (https://www.excelbanter.com/new-users-excel/27940-excel-2000-how-use-filters-protected-workbook.html)

Jimmar

Excel 2000 how to use filters in protected workbook

I am using MS Excel 2000 and I want to password protect a worksheet to
protect the format and formulae but still allow users to use the filter
facility. Is this possible?

Ron de Bruin

Hi Jimmar

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Jimmar" wrote in message ...
I am using MS Excel 2000 and I want to password protect a worksheet to
protect the format and formulae but still allow users to use the filter
facility. Is this possible?

All times are GMT +1. The time now is 01:38 AM.