Hello all
Is it possible to share and protect and unshare and unprotect in VBA. I have found the activeworkbook.exclusiveaccess and the unprotectshare and protectshare properties but am having difficulty piecing it together as I have to keep messing about to access the code as the shared book doesnt allow this obviously.
Has anyone come across this. I need it to do this to make it more foolproof for less literate members of the staff.
Cheers
Neil
Is it possible to share and protect and unshare and unprotect in VBA. I have found the activeworkbook.exclusiveaccess and the unprotectshare and protectshare properties but am having difficulty piecing it together as I have to keep messing about to access the code as the shared book doesnt allow this obviously.
Has anyone come across this. I need it to do this to make it more foolproof for less literate members of the staff.
Cheers
Neil