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