Wow this is nice.. I was expecting that when Yes is selected the rest will just set as No manually.
This one is great that whenever the Yes is selected the other will turn into No automatically.
Thank you so much @vletm for helping me on this.
Hi @vletm yes actually I want to use VBA Macros on this however when I tried to do it in my working file, the changing of Yes into No seems not working well. Sorry for the confusion, I used the word we not for some group here, I used it as You and I.
If it is not too much to ask, can you check my VBA scripts as I know there is something wrong. Thank you in advance.
Basically the validation should be when I select Yes in one of the Financial Management simple, medium or complex the other 2 will set to No. Same validation to when I select Yes to Dunning simple or medium only one should be in yes and also in Advanced Order Management SIMPLE or Medium.
I would like to ask on how I can hide and unhide the rows in a locked sheet? I have attached again the file the we use before and the only problem now is that whenever I tried to locked the sheet, the hiding ang unhiding of rows for AMO Package is not working anymore. The password is 123. Appreciate your help again on this. Thank you in advance.
With which setting did You try to lock?
If You would like to hide row then there should be allow to [un]hide rows.
I added that missing functionality. Hint: Those Sheet1's cells should unlocked, which users needs to use. If users can ... do what ever ... then user would do so.