ExcelBanter - Lock / Unlock Cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Lock / Unlock Cell (https://www.excelbanter.com/excel-programming/278333-lock-unlock-cell.html)

terence

Lock / Unlock Cell

Hi,

I would like to lock / unlock a whole column by using VBA
code. How to do it? Anyone knows?

Thanks.

Terence

DomThePom[_4_]

Lock / Unlock Cell

(use the recorder!!)

Columns("H:H").Locked = False
Columns("H:H").Locked = true

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

All times are GMT +1. The time now is 11:38 PM.