My question is pretty simple, but one to which I can't really find a solution myself. I use Excel quite frequently, but rarely the fancy stuff. Anyway, to the point:
How do I create a dropmenu that will lock certain cells, rows or columns? (by lock I mean unable to change via hand and stops...
To the Excel Gurus: How can one lock columns, so that subsequent changes to criterias of 'formula applied' will not affect the locked column, while, current data columns are active are good. An application of data validation drop down menu with option "LOCK" "UNLOCK" is preferred. Say e.g...