VB Code to Share Workbook

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.
 
D

Dave Peterson

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.
 
S

SJW_OST

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...
 

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

Similar Threads

share workbook help 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Can't share workbook. The "Share Workbook" option is off. Why? 4
Greyed-out Share Workbook button 3
Share Workbook command is not available (greyed out) 3
Excel Macro-enabled Workbook 2
Shared Workbook creating Backup when saved? 1
share workbook is greyed out 1

Top