Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to protect the colum in excle sheet
i want to create the vb script for excel sheet in that the in any
colume in the excel sheet the valu will be enter by me which no one else can chagen and |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to protect the colum in excle sheet
After making all your entries, go to Tools=Protect=Protect sheet. Assign a
password and click OK. The default state of cells in a sheet are locked, so this assumes you have not unlocked any cells. when protection is applied (without any exceptions) then this will prevent modification. Note that worksheet protection can be broken, so it is just a safety. -- Regards, Tom Ogilvy "Bharat" wrote: i want to create the vb script for excel sheet in that the in any colume in the excel sheet the valu will be enter by me which no one else can chagen and |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in MS EXCLE how we can protect only one cell? | Excel Worksheet Functions | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
how to sum a complete colum on another sheet in VBA | Excel Programming | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
Lock and protect cells without protect the sheet | Excel Programming |