It can be doen by writing a simple macro, wherein you will have to use two
properties
You will have to mention that a prticular cell in column A if it is true
then select the corresponding cell in column B / C / D and then
Selection.Locked=True
and
ActiveSheet.Protect ("Password")
these two will
Yes, this is possible.
What you're looking at is using the Protect Sheet functionality.
Try recording a macro and Protect/unprotect a sheet.
Now, are you wanting to make SURE that the user cannot modify or see the data?
or just make it easier to use?
If you're wanting to make SURE, then you'll hav
