Hi.
I am currently making some excel workbooks for work (production list, recipe template, etc.). One problem that has happened on earlier versions,is that some of my coworkers distort some of my calculations, and they are not able to fix it themselves. I solved this by locking the cells that contains formulas with password. But now, I am expanding it, and have to use Grouping (Data toolbar --> Group), and I am not able to lock the cells in that way.
I got a hint that recommended me to make a Macros button that reset the entire workbooks formulas to what I set as a standard.
Anyone that can tell me how to do that? Or show me in the test document i added here. This is NOT the biggest workbook, that one has about 70 sheet's with more than a total of 10million pre-filled(functions, macros, names, order numbers, etc.) cells + maybe 2000 macros when done. I only need to know how to do it.
And is it better to have one "Reset" macros on each sheet, or to have one for the whole workbook?
In the test document, the blue cells are the ones that need the "reset" macros, and the yellow ones can not be changed by it. (it's in Norwegian, by the way)
If you need more explaining or the document in English, tell me and I'll try my best.
Test doc.xlsm
Regards
AMosand
Bookmarks