VB Code to Share Workbook

  • Thread starter Thread starter SJW_OST
  • Start date Start date
S

SJW_OST

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.
 
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.
 
Thank you! It works like a charm :)

Dave Peterson said:
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.
Click to expand...
 
Back
Top