Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking Cells in an Automated SpreadSheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking individual cells in an excel spreadsheet | Excel Worksheet Functions | |||
Help with automated size in cells and two lines | Excel Discussion (Misc queries) | |||
Locking cells in a spreadsheet | Excel Discussion (Misc queries) | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
need help with locking spreadsheet | Excel Discussion (Misc queries) |