Code to turn off Share Workbook

E

Ed

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top