View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keithb keithb is offline
external usenet poster
 
Posts: 44
Default Question about ExclusiveAccess

What is the difference between:

If ActiveWorkbook.MultiUserEditing Then
ActiveWorkbook.ExclusiveAccess
End If
ActiveWorkbook.Save

and;

ActiveWorkbook.SaveAs AccessMode:=xlExclusive

Do the both accomplish the same thing?

Thanks,

Keith