I know how to lock a cell within a locked workbook. However, how can i lock a cell with a different password from that of the workbook? thanx!
Locked cells (the default) have no effect until you apply Worksheet Protection. Simply go to Tools>Protection>Protect Sheet and apply a different password than the one used to Protect the Workbook.
but is there a way just to protect one cell? for say a formula?
Yes, unlock all cells, then lock the one cell and protect the sheet.
Excel 2002 + also has a funky feature which allows you to set ranges that can be edited when the sheet is protected if a password is supplied.
You can set a general sheet protection password which only you know .(warning: all sheet protection passwords are defenseless against medium - advanced users)
You can then assign differnt passwords that allow specifiec ranges to be edited by a user.
You can find this utility under Tools - Protection - Allow users to edit ranges. This is quite a handy feature to restrict multi level users but be warned - it will only keep out the honest people.
thanx for your help, so basically it is not possible to protect one cell with a different password from the workbook that will get by even advanced users ha!