hi folks,
I have a shared workbook where there are multiple users who would need to unshare workbook to carry out certain activities, my problem is that the user may forget to re-share the workbook again, thus restricting others from populating the file.

I was hoping to create a command button to run a macro which would re-share the workbook and save workbook. I tried to record the macro but a error appears when i select share workbook. I was wondering would a VBA code solve this, I have no experience with VBA so would need the code as well.

I'm working off of Excel 2010

Thanks,
Brian.