Hiya Roger,
The question was a little ambiguous, but I was thinking something bigger that dealt with specific users:
Starting with Excel 2002, if you have a domain at work, you can lock cells and give permissions to certain individuals to be able to edit them. To do this:
- Excel 2002/2003 Tools-->Protection-->Allow Users To Edit Ranges
- Excel 2007+ Review-->ChangesàAllow Users To Edit Ranges
The dialog box that results is shown below. Its concept is that you need to specify the ranges that users CAN edit. To do so you’d click New.
Once done, you’ll see the dialog box shown below:
Give the range a title and a range then also provide a password. This is a very important step, as if you do not provide a password then this setup will have no effect.
Finally, click Permissions and add the users you wish to include. And don’t forget to include yourself or you may also be locked out (which can, of course, be undone by unprotecting the workbook).
While we have tested this interesting feature in our offices, I admit it is not one we use, as it seems like it would be difficult to maintain. Regardless, it could offer value in some situations.