Disable exclusive user prompt

[impresxy]

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 ?

Please Login or Register  to view this content.

prompt.PNG

[:) Sixthsense :)]

When you ask excel to give ExclusiveAccess then surely all the users will be kicked out.

[impresxy]

Hi Sixthsense,

Yes, that was my purpose. I am asking to hide this prompt. I just dont want to have so many prompt for everytime I want to run my macro.

[:) Sixthsense :)]

Please Login or Register  to view this content.

[impresxy]

Hi,
Thank you very much, Sixthsense