View Single Post
  #1 (permalink)  
Old July 14th, 2011, 12:28 AM
bensonrobert10 bensonrobert10 is offline
Registered User
 
Join Date: Jul 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Protect a cell in excel using vbscript

hi,

How to lock a particular cell from editing in excel using vbscript . Tried in C# it works but not able to make it to work in vbscript. Please help.Tried the below code

objExcel.Cells.Locked = false
objExcel.Range("A2:B2").Locked = true
currentWorkSheet.Protect "Test",0,0

It doesnt work...
Reply With Quote