| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
urgent, how to lock entire column upon load?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I lock specific cells w/o having to protect entire sheet? | Excel Worksheet Functions | |||
| urgent help with lock excel macros!!! | Excel Discussion (Misc queries) | |||
| need to lock 5 cells but not protect entire sheet | Excel Discussion (Misc queries) | |||
| If data in one column, take date, add 2 days, and turn the entire column a color... | Excel Discussion (Misc queries) | |||
| How do change entire worksheet to uppercase letters and lock it | Excel Worksheet Functions | |||
Linear Mode
