All,
I have a macro to lock my workbooks for field distribution - ShowPass. Each worksheet has the "select locked cells" unchecked. The cells which require data entry I will individually go to cell properties and uncheck "locked". Once the macro runs, it locks every sheet except the cells pre-selected to be unlocked.
The field guys will enter data into the unlocked cells. This macro was created to standardize all inspection forms....
I would like to have a macro which locks every cell, every sheet in a workbook, regardless of the worksheet "Protect Sheet" properties. My thought is when I send a sample workbook out for review. Absolutely, no data entry will be able to occur.Please Login or Register to view this content.
Bookmarks