ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable Sharing mode in VBA (https://www.excelbanter.com/excel-programming/339533-disable-sharing-mode-vba.html)

keithb

Disable Sharing mode in VBA
 
What Workbook properties need to be changed to disable Sharing when a
workbook is opened.

Thanks,

keith



Jim Rech

Disable Sharing mode in VBA
 
If ActiveWorkbook.MultiUserEditing Then
ActiveWorkbook.ExclusiveAccess
End If


--
Jim
"keithb" wrote in message
...
| What Workbook properties need to be changed to disable Sharing when a
| workbook is opened.
|
| Thanks,
|
| keith
|
|




All times are GMT +1. The time now is 05:21 PM.

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