Lock/Unlock cells

[suresh_bowman]

how can i lock & unlock a particular cell or a range of cells from Visual Basic
This message was edited by suresh_bowman on 2002-08-29 22:04

 

[Ivan F Moala]

On 2002-08-29 21:58, suresh_bowman wrote:
how can i lock & unlock a particular cell or a range of cells from Visual Basic
This message was edited by suresh_bowman on 2002-08-29 22:04

Turn on your macro recorder and do the steps required for this. Stop recording and see what you get.
If you have problems implimenting what you have recorded then post back with relevant info...eg Error number,text, Xl version etc

 

[AChimpNamedCornelius]

What if Macros->Record New Macro... is grayed out?

Where is the button that's labeled "Un-gray-out the Macros->Record New Macro... Menu Item, Please"

And no, the .xls file, nor the worksheet, nor the selected cell(s) are locked.


Seriously, I would like to ensure a group of cells are locked, too, and do it in the Private Sub Workbook_Open() procedure.


Needless to say, things like:

application.Worksheets("BuffyRulz").Range(some cell ref, some other cell ref).Locked = True

Excel barfs on completely. With all the orthogonality built into the Range object, the Range object is curiously unorthogonal. Like they built it, but they won't let you use it.
This message was edited by AChimpNamedCornelius on 2002-09-09 13:45
This message was edited by AChimpNamedCornelius on 2002-09-09 13:46

 

[AChimpNamedCornelius]

To sum up, I can't even get as far as recording a macro. I just need to work the labyrinth of what.what.whatelse.esoteric.lock = true
This message was edited by AChimpNamedCornelius on 2002-09-17 06:24