| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking non-blank cells of all worksheets before closing the workb
Dear all, I am looking for a code that will lock all the non-blank cells
(within all the worksheets of a workbook) once the workbook is closed. I imagine that, upon closing the workbook, the code will search for the non-blank cells and will turn the protection from "Unlocked" to "Locked". What would this code be? Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i need to save the same header to use on all worksheets in a workb | Excel Discussion (Misc queries) | |||
| Locking Cells or worksheets | Excel Worksheet Functions | |||
| link to worksheet from several other worksheets in different workb | Excel Discussion (Misc queries) | |||
| Link different worksheets in different workbooks to 1 master workb | Excel Discussion (Misc queries) | |||
| How do you protect hidden linked worksheets with in an Excel workb | Excel Discussion (Misc queries) | |||
Linear Mode
