microsoft excel training in london - Can I password protect a range within a worksheet? | Excel forum

Matthew

You can also password protect areas within a worksheet, and for only certain users. If you go to Protection, Allow Users to Edit Ranges (in the toolbar), then click 'New', you can enter the range that you want, and ascribe a user (which you pick through Microsoft Exchange) to have access to that range. When they are logged in through Windows, they will be able to access that range, and anyone else attempting to will be prompted for a password. The user who can access the range does not need the password.

I don't know if you can do this with unlimited ranges in a single worksheet, but you can certainly do it with several. It can be useful for example when you want one person to be able to enter data, and someone else to approve it, without having to use paper and signatures.

You do also need to have those ranges 'locked' and the worksheet itself protected in order for this function to work.

Hope that all makes sense - post back if not.

Tristan