Lost_in_Excel
New Member
- Joined
- Oct 22, 2010
- Messages
- 20
Hi all
I'm developing a planning tool for multiple areas. I've got it to do what I want and I've protected it appropriately. The tool needs to be available to a large number of people but there are a few columns with sensitive data (salary, etc) that I'd like to be visible to only a few people.
My question. Is there a way to have two (or more) levels of protection. One to lock the sheet down to prevent the formula being changed and a separate level of protection to allow columns to be hidden/unhidden whilst leaving the formula protection untouched.
Thanks for any help.
I'm developing a planning tool for multiple areas. I've got it to do what I want and I've protected it appropriately. The tool needs to be available to a large number of people but there are a few columns with sensitive data (salary, etc) that I'd like to be visible to only a few people.
My question. Is there a way to have two (or more) levels of protection. One to lock the sheet down to prevent the formula being changed and a separate level of protection to allow columns to be hidden/unhidden whilst leaving the formula protection untouched.
Thanks for any help.