View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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/