accessman2
04-24-2007, 06:33 AM
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
04-24-2007, 08:28 AM
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.
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.