urgent, how to lock entire column upon load?
 

what is the code to lock 1 entire column upon auto load

--
Message posted from http://www.ExcelForum.com

urgent, how to lock entire column upon load?
 

Sub auto_open()
Activesheet.Unprotect
columns(1).Cells.Locked = True
Activesheet.Protect
end Sub

but cells being locked is the default.

--
regards,
Tom Ogilvy

shirley wrote in message
...
what is the code to lock 1 entire column upon auto load?


---
Message posted from http://www.ExcelForum.com/

urgent, how to lock entire column upon load?
 

thx

--
Message posted from http://www.ExcelForum.com