I have sensitive data in 2 columns (say G and H) which I have grouped so that I can hide and/or unhide. Can I restrict some users from unhiding either by password or any other method. Thanks
I have sensitive data in 2 columns (say G and H) which I have grouped so that I can hide and/or unhide. Can I restrict some users from unhiding either by password or any other method. Thanks
Last edited by spimturn; 07-23-2012 at 07:37 PM. Reason: meaningful title
Hello spimturn, and welcome to the forum.
Thanks for amending your title.
Last edited by Cutter; 07-25-2012 at 07:30 AM. Reason: Removed title change request
oops, sorry. Have now changed. As a "old bloke" from way back, Ihope you will forgive me.
you can select all the columns that can be edited then
-format cell - untick the "lock cell option" -
then you can protect sheet -untick the "select locked cell"
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thanks vlady, your solution was very helpful
your welcome...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks