I think you need to think about how strong you want to make the protected
part of the sheet.

One solution would be to have an area of your sheet set aside for a short
acceptance statement by your boss, but is by default left blank.

Then have a non-printed command button button on the sheet that when clicked
ran some VBA which asked you for a password, and then assuming the password
was correct automatically entered the acceptance statement on the sheet.

You would probably need to add some VBA code into the Change Worksheet event
that checked for changes to your key cells, and removed the acceptance
statement.

On a legal(ish) note, you might also want o add something to your sheet tat
say something about the acceptance being electronically generated, and a
written signature not being necessary. I wrote an application for a client
recently doing something similar, and it was acceptabvle as an ISO 9000
approved system.

If you need more detailed help, then please re-post, but hopefully this
will be enough to get you started.

Neil
www.nwarwick.co.uk

"Ciara" wrote:

hello.

I am working on a quote tool in excel. people go into the spread sheet -
make their selections and it will come up with a final cost.

at this stage my boss has to validate the quote. I need there to be some
part of the sheet that only he can access and maybe tick a box to say he has
validated the quote.

once he has done this if anybody changes anything in the spreadsheet it
should loose his validation.

any help is appreciated!