G
Guest
Many users access data for my application. The data is stored on seperate xl
files. These data files only open long enough for information to be retrieved
form or saved to, then the file is closed. If by chance the file to be opened
is already open by another user and in a Read Only state, my application
displays a MsgBox to "try again". However, a default windows message appears
well after this event, advising that the file is now Read Write and available.
Is there any way to prevent this Windows message from appearing, similar to
setting DisplayAlerts to false?
files. These data files only open long enough for information to be retrieved
form or saved to, then the file is closed. If by chance the file to be opened
is already open by another user and in a Read Only state, my application
displays a MsgBox to "try again". However, a default windows message appears
well after this event, advising that the file is now Read Write and available.
Is there any way to prevent this Windows message from appearing, similar to
setting DisplayAlerts to false?