Log in
x
or
x
x
Register
x

or

unanswered Please help! VBA to lock cells based data in other cells

  • louisetaitt@gmail.com
  • louisetaitt@gmail.com's Avatar Topic Author
  • Offline
More
2 months 6 days ago #1938 by louisetaitt@gmail.com
Please help! VBA to lock cells based data in other cells was created by louisetaitt@gmail.com
Hi,
Can someone help with the following.
Say for instance I have columns A,B,C,D & E which can be edited by users, is there a way that I can lock the data in columns A-E for certain rows based on a value in the adjacent cell?
E.g. Column F for each row may show as "blank, no or yes" ... but if any cells in column F state yes, then it will lock the data in columns A-E for that row?

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun