-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Vba share workbook
- Thread starter yoko
- Start date
gaj104
Well-known Member
- Joined
- Nov 9, 2002
- Messages
- 864
Hi
The only way I can think to share macros is to have a seperate workbook which contains all your coding that everyone opens in read only mode, with vb references made to the shared book, if that makes sense?
It does mean that 2 workbooks are open, but maybe you you can put a note in the shared workbook for each user to open the "vba" workbook.
Hope it helps
The only way I can think to share macros is to have a seperate workbook which contains all your coding that everyone opens in read only mode, with vb references made to the shared book, if that makes sense?
It does mean that 2 workbooks are open, but maybe you you can put a note in the shared workbook for each user to open the "vba" workbook.
Hope it helps
Upvote
0
MorganO
Active Member
- Joined
- Nov 21, 2006
- Messages
- 483
Yoko,
I've found a way to do what I think you want.
To share a workbook using vba use this code:
Where 'FileName' is the path and name of your file. The file MUST be saved in order to enable sharing.
To unshare the workbook use this code:
I would recommend saving the file as well immediately after changing it from Shared to unshared:
Hope this works for you.
Take Care.
Owen
I've found a way to do what I think you want.
To share a workbook using vba use this code:
Code:
ActiveWorkbook.SaveAs FileName, , , , , , xlSharedWhere 'FileName' is the path and name of your file. The file MUST be saved in order to enable sharing.
To unshare the workbook use this code:
Code:
If ActiveWorkbook.MultiUserEditing Then
ActiveWorkbook.ExclusiveAccess
End IfI would recommend saving the file as well immediately after changing it from Shared to unshared:
Code:
ActiveWorkbook.SaveAs FileNameHope this works for you.
Take Care.
Owen
Upvote
0
Hi,
i have one small question.
how can you use the code for unsharing after you shared the workbook, as when the workbook is share you can no longer access the macros?
i have one small question.
how can you use the code for unsharing after you shared the workbook, as when the workbook is share you can no longer access the macros?
Upvote
0
Similar threads
- Question
