Thank you! It works like a charm :)

"Dave Peterson" wrote:

Open your workbook.
Start a new workbook
Start recording a macro in this new workbook
change workbooks
change to share (or unshare)
Stop recording

You'll see the code in the new workbook.

SJW_OST wrote:

I have a file that is used everyday and is set to Share Workbook, not share
workspace, so that multiple people can update the file at the same time by
saving any changes made.

What I want to do is use VB Code to select/deselect Share Workbook...
I have been unable to record the process.

--

Dave Peterson