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 |
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 |
All times are GMT +1. The time now is 12:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com