View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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
|
|