Read Only message

[accessman2]

Hi,

I create one Excel file in the sharing drive. If multi user access this file at the same time, the user will get the Read-Only message when opening. Can I skip/remove the Read-Only message?

 

[unmarkedhelicopter]

And do what ?
If you don't want the shared access you want dumping out without a spreadsheet ?
If you do then you will just have read access and won't be able to save the file.
So what are you trying to acheive ?

With code (run from where ?) you could ingnore the message and just have read only access. You'd need "application.displayalerts = false" in the code just prior to opening the file and to put things right "application.displayalerts = true" just after.

 

[RayH]

Have you tried turning on Sharing?
In Excel, Tools, Share Workbook.
This will allow multi-user access and changes at the same time.
The user will be informed if any changes they have made impact another users changes when they save the spreadsheet.