Good morning
I have a large spreadsheet with many grouped cells
the spreadsheet shows training done by people
the training is in categories, so i have these categories with subcategories grouped
one of the categories is very personal so i want to lock these so when people look at my spreadsheet they cannot open these grouped cells without a password
but they can view the other groups (categories)
can anyone help?
Thankyou in advance
If you are using 2007, you can put your sensitive info on another sheet, and then use the VBA editor to "very hidden" that worksheet. That way, if no1 knows its there, no1 would even bother to look for it
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The boss is wanting it all on one page
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks