Hi everyone,
I have a shared file where I allow editing template to only one admin. I use below code to make this admin as an exclusive user.
Everytime this code run, there is a prompt message asking to remove other users. Is there anyway to disable this
prompt showing up? Can you please suggest ?
If ActiveWorkbook.MultiUserEditing Then ActiveWorkbook.ExclusiveAccess End If
prompt.PNG
Bookmarks