Lock Cell After Data is Entered on Particular Cell
On Sun, 24 Jun 2012 12:00:21 +0000, Moideen
wrote:
We are maintaing an excel sheet for expense details, After Entering the
data on Amount Coloumn Need to Lock The Amount Coloumn with Password.
Please help me.
Coloumn 1 Coloumn 2 Coloumn 3
Date Item Name Amount
Unlock cell, add data, re-lock cell.
All has to be by code. No auto-function for this. You must visit the
programming sub-group.
|