I have a shared workbook with 2 'Protected sheets, one is being used as a
form to allow user to enter into fields and click on the button which prints
the sheet and enters the field data onto sheet 2.
The problem is that I need to first unshare the workbook complete the rest
of the tasks and then lastly turn the share workbook and close.
Can anyone pass on some code to turn off 'share workbook' and then turn back
on?
Thank you!