Hi there! I have a dilemma I just cannot figure our how to solve. I need to make an excel document easy-to-use for the masses (aka company I work for) that calculates stuff based on input they give into a column. The problem is that I can't allow these lovely people to change the formulas (in other columns -- the ones that calculate based on values the user enters in the first column), or they will end up ruining the document for everyone. My problem is that I do need them to be able to select the CELL VALUES to use in our reports, and there can be up to 20,000 rows of data they'll need. Is there anyway, programmatically or otherwise, to make these sheets so that the formula cells are un-editable but still selectable to copy their resulting values? (If it's just not possible, I'll have to live with that, but I wanted to make sure, and figured if anyone would know, it's you guys!!) Either way, thanks so much for your help!
~CR
Bookmarks