ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   shared workbook (https://www.excelbanter.com/excel-programming/376367-shared-workbook.html)

Justin

shared workbook
 
Need some assistance. I found code here where I can create a shared excel
workbook and also unshare it.
But when I try to unshare it, there is a dialog box, prompting user to
select yes or no to unshare book. Is there a way that I can not have that
dialog box and automatically unshare it. thanks

here is the code that I have:
If ActiveWorkbook.MultiUserEditing Then
ActiveWorkbook.ExclusiveAccess
End If



If Not ActiveWorkbook.MultiUserEditing Then
ActiveWorkbook.SaveAs Filename:=ActiveWorkbook.FullName, _
accessMode:=xlShared
End If


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com