unshare excel workbooks Anonymous persons

[sekhar03]

This is my first Post/question.

I've a workbook and lets say I shared the same with group of 30 more people. I want the workbook to be accessed by only the group of 30 people. If the same excel shared out of the group, it should not be accessible. Else, I want the workbook to be accessed by only authorized persons.

 

[JLGWhiz]

Password protect the workbook and only give tghe password to the those you want to access the workbook. The share feature is either Shere, Exclusive or Read Only. Sharing does not allow selective parties to be included or excluded, it has to be done with a password. However, with some more elaborate code, you could check the User environs and bounce that against a list of approved users to grant access. But the password should work just as well.

 

[sekhar03]

Password protect the workbook and only give tghe password to the those you want to access the workbook. The share feature is either Shere, Exclusive or Read Only. Sharing does not allow selective parties to be included or excluded, it has to be done with a password. However, with some more elaborate code, you could check the User environs and bounce that against a list of approved users to grant access. But the password should work just as well.

Thanks for the reply. I can share the password with Authorized people only. Those Authorized people can also share the password with some others (might be unauthorized) as the password is same for all.
you could check the User environs and bounce that against a list of approved users to grant access. -- This seems good. But my users are using excel in Android Mobiles as well. I don't think mobile supports Macro enabled excel.

 

[JLGWhiz]

Impasse!