| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VB Code to Share Workbook
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VB Code to Share Workbook
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VB Code to Share Workbook
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't share my workbook...Why? | Excel Discussion (Misc queries) | |||
| why can't i share my workbook | Excel Worksheet Functions | |||
| Can't share workbook. The "Share Workbook" option is off. Why? | Excel Discussion (Misc queries) | |||
| Share Workbook | Excel Discussion (Misc queries) | |||
| share workbook | Excel Discussion (Misc queries) | |||
![SJW_OST[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
