In excel 07 how do I lock filters and lock "hidden" tabs.

I work in a high security area and I want to send a spread sheet to different people, each just knowing what is their info.

I want to password protect filters and hidden tabs !

they are free to do what ever they want with their own data !!

Dave
TIMFOX123Asked:
Who is Participating?
 
xtermieConnect With a Mentor Commented:
Also for worksheet - workbook
On the Tools menu, point to Protection, and then click Protect Workbook.
Do one or more of the following:

To protect the structure of a workbook so that worksheets in the workbook can't be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be inserted, select the Structure check box.

To protect windows so that they are the same size and position each time the workbook is opened, select the Windows check box.

To prevent others from removing workbook protection, type a password, click OK, and then retype the password to confirm it.
0
 
Rory ArchibaldCommented:
Excel is not secure so if you require high security, don't include data that is not relevant to that user in the workbook you send them.
0
 
dandrakaConnect With a Mentor Commented:
Try this...for cells - to not edit formulas etc:
(1) Select all cells you want protected and right click
(2) then select Locked and Hidden
(3) then go to Tools ==> Protection ==> Protect Sheet
(4) type in your password
(5) deselect everything
0
 
TIMFOX123Author Commented:
thx.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.