| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock and Unlock Cells
Hello All,
I am trying to get my sheets to work as follows: Unprotect the worksheet (with password) Protect cell range B16,D45 Unprotect cell range N16,N45 Protect sheet (with password) Then move to the next sheet in the Workbook and repeat the process. There are 20+ Worksheets in the Workbook. Regards Peter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Check Box to Lock/Unlock Cells | Excel Discussion (Misc queries) | |||
| Lock or Unlock Range of Cells on Worksheet_Change Event | Excel Worksheet Functions | |||
| Protection - Allow Group/Ungroup but lock / unlock some cells | Excel Discussion (Misc queries) | |||
| Lock/Unlock cells | Excel Worksheet Functions | |||
| Lock and Unlock cells using VBA | Excel Discussion (Misc queries) | |||
Threaded Mode
