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....

Please Login or Register  to view this content.
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.