Hi all,
If it is not too much to ask I was wondering whether someone can help me with the below code.
Basically I have a workbook which contains numerous macros which I have assigned to different command buttons.
I would like to protect the workbook so as to ensure data input in some cells but not in others. At the same time I would like to ensure that all macros will still be functional when I hit the command buttons.
I was trying to use the below code, however, I am still getting some errors.
Please Login or Register to view this content.
If it is possible, is there a better code which could be used and which will permit all macros to be executed?
(P.S: also tried to insert code in existing macros to unprotect and re-protect but to no avail).
Appreciate a lot your kind help!
Thanks
Keibri
Bookmarks