CELL LOCK

[MANOJ GHOSH]

i WANT LOCK COLUMN "C" & "D" & ONCE COLUMN "B" ENTER THEN IT IS AUTO LOCK..TO EDIT GIVE PASSWORD..
PLEASE HELP ME HOW CAN I DO IT..

 

[Marc L]

PROTECT CELLS AND
PROTECT WORKSHEET WITH A PASSWORD ‼
​

 

[bobhc]

The security in Excel is about as good as an ash tray on a motorbike....bloody useless.
No matter what you do ether protecting the work sheet or the full work book the protection can be undone....quite easily.


.

 

[bobhc]

@Marc L resorted to shouting to get your message across.....


.

 

[bobhc]

@Marc L, yep your edit really comes across loud and clear, I can feel the ear wax moving....



.