Hi,

I am creating a spread sheet which will be used to lay out bills of
materials (BOMs). The BOM is a list of all the manufacturing components which
are needed to created a finished product. Roughly 50% of the components are
generic and constant so Ive created a number of drop-down menus which the
user must fill in, when they are all selected the 50% of the BOM which is
generic autopopulates with partnumbers, qtys etc.

Its important that the user doesnt overwrite the formulae in these cells
but at the moment there is nothing preventing that from happening so what I
need to know is, is there a way of locking these cells so that they cant be
overwritten without a password but they can be formatted, deleted etc.?

Also is there a way of locking the choices in the drop down lists so that
once the user has made their selection there is a warning which appears if
they try to change the selection? It would be preferable if I could set up
the spreadsheet so that the user has minimal steps to remember i.e. format
cells €“ protection tab €“ etc.

Many thanks,
Mick