| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lock and unlock cells programatically
How would I lock and unlock cells (protect) programmatically. Say I have a
Range myRange - How would I Protect those for editing? Thanks in advance for your help Call_Vishwa |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
lock and unlock cells programatically
Try recording a macro when you:
Unprotect the worksheet select your range format|cells|protection tab (lock those cells) reprotect the worksheet. It should be pretty close. call_Vishwa wrote: How would I lock and unlock cells (protect) programmatically. Say I have a Range myRange - How would I Protect those for editing? Thanks in advance for your help Call_Vishwa -- Dave Peterson |
| Reply |
| 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 | |||
| Lock/Unlock cells | Excel Worksheet Functions | |||
| Lock and Unlock Cells | Excel Programming | |||
| Lock and Unlock cells using VBA | Excel Discussion (Misc queries) | |||
![call_Vishwa[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
