Prevent users from changing parents without sheet protection

[Former Member]

Hello ,

Is there a way to prevent users from changing numbers(by mistake)in parent accounts in an input form without protecting worksheet? (note - I am not talking about changing numbers in BPC database, I understand that its not possible to send data to parents in BPC anyway) I have a client requirement to accomplish this without protecting the worksheet or workbook. I cant figure out a way to do this without protecting worksheet/book. thanks.    

[Shrikant_Jadhav · Accepted solution]

Hi Zalak,

As far as I know, there is no other way. Even if you use VBA , it has to be protected, other wise user can edit the number in cell.

You can do some conditional formatting to highlight changed cell.

What is the logic behind not to protect sheet ?

Shri

[Former Member · Accepted solution]

Its a bit unique client requirement, too long of a reason to give here. but basically they want users to not be able to change parent numbers without protecting the sheet. thanks.     

[Shrikant_Jadhav · Accepted solution]

Hi Zalak,

It's strange, As business, what's the matter if you are protecting sheet ? 

There is another option, use data validation for parent member, if user tries to input at parent level , show pop up message.

Shri