IrishCharm
10-20-2009, 02:38 AM
Hi,
I was just wondering if it is possible to filter a workbook when the tab is protected? Basically I want people to be able to filter but i dont want them to change anything! I have tried a few different things, including locked/unlocked row 1 where the filter is going to be on but nothing seems to work. Is there a way to by-pass this whereby i can protect a tab but also leave a filter in place whereby people can filter but not make changes?
Thanks
Sarah
I was just wondering if it is possible to filter a workbook when the tab is protected? Basically I want people to be able to filter but i dont want them to change anything! I have tried a few different things, including locked/unlocked row 1 where the filter is going to be on but nothing seems to work. Is there a way to by-pass this whereby i can protect a tab but also leave a filter in place whereby people can filter but not make changes?
Thanks
Sarah