on 02-01-2015 10:02 PM
Dear all,
The requirement is to lock input-ready cells on a Excel button click. We don't want to use the standard "Lock Cells" button provided in Planning Ribbon.
Button functionality is implemented in VBA Macro, But i am not able to find any information on How to trigget the AFO "Lock Cells" there. An option of Excel Locking is possible, but it only works when we protect the whole worksheet and in our case it is useless.
Any ideas?
Thanks & Regards,
vamsi.
Hi vamsi,
did you find a solution for this problem?
We have the same need in our project.
Best regards,
Igor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Igor.
I could not lock the cells using a macro but I reached something useful.
Best regards,
Nacho
The toggle between display and change button will give the functionality you are looking for. You will see the button once you enable the planning ribbon under AFO settings.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.