Hello,

I have an Ewcel File with VBA Macros.

This file is shared on Sharepoint and have to be use in multi user access mode.

Actually, when I open this file, an Excel panel is show up with the folowing message :
"Server File : To modify this file, clic on Modify file button"

If no one clic on the button, the file is enable for every body but no modification will be save on sharepoint

If a user clic on the button (activation of function ActiveWorkbook.LockServerFile), the modification saved will be accepted on sharepoint but no one else will be able to clic on the button until the close of the file.

I'm looking for a function to:
1/ Don't show the message "Server File : To modify this file, clic on Modify file button"
2/ Set on readonly mode by default
3/ Reload the file before edit
4/ Set on LockServerFile before save
5/ Save the file
6/ Reload the file after save in readonly mode

Can you help me?

Ps : Sorry for my "English"