polisasimo
New Member
- Joined
- Jul 27, 2007
- Messages
- 12
Hello Everyone,
I am new to the forum and this is my first post. After searching the forum for a problem similar to my own I, with limited sucess, I have decided to pose the following scenario.
I have a workbook with several pages each containing a group of data that has been transformed into a list. This allows any one viewing this workbook the option to filter some of the data based on the list functionality.
I would like to apply some protection to the data that is contained in the list but when I apply security to the worksheet with the header columns unlocked, thus making them selectable the sorting and filtering of the data is not available.
I assume this is because the cells which hold the lists data are locked and the sheet is protected.
Any ideas on a way to allow list functionality (sorting, filtering) while still protecting the contents of the list?
Thanks in advance.
I am new to the forum and this is my first post. After searching the forum for a problem similar to my own I, with limited sucess, I have decided to pose the following scenario.
I have a workbook with several pages each containing a group of data that has been transformed into a list. This allows any one viewing this workbook the option to filter some of the data based on the list functionality.
I would like to apply some protection to the data that is contained in the list but when I apply security to the worksheet with the header columns unlocked, thus making them selectable the sorting and filtering of the data is not available.
I assume this is because the cells which hold the lists data are locked and the sheet is protected.
Any ideas on a way to allow list functionality (sorting, filtering) while still protecting the contents of the list?
Thanks in advance.