How can I filter a worksheet that is shared and protected? am using Excel 2000.
L larry Feb 5, 2004 #1 How can I filter a worksheet that is shared and protected? am using Excel 2000.
D Debra Dalgleish Feb 6, 2004 #2 You can't change the protection on a shared workbook, so you won't be able to enable filtering on a protected sheet. If the workbook is not shared, you can set protection to User interface only as the workbook is opened. There are instructions here: http://www.contextures.com/xlautofilter03.html#Protect
You can't change the protection on a shared workbook, so you won't be able to enable filtering on a protected sheet. If the workbook is not shared, you can set protection to User interface only as the workbook is opened. There are instructions here: http://www.contextures.com/xlautofilter03.html#Protect
