Msgbox in WorkBook_Open event

[Corey ....]

IF a workbook is already Open by another user on a small office network, and
I open it i do not know it was already opened by another user, i get a Read
ONLY error when i close the file with a macro that saves before closing.

Is there a way i can prompt the user that the Workbook is currently Opened
by "User Name, please try again later", then close the file after closing
the msgbox.

Corey....

 

[Jim Rech]

A workbook's ReadOnly property will be True if it was opened read only.

--
Jim
| IF a workbook is already Open by another user on a small office network,
and
| I open it i do not know it was already opened by another user, i get a
Read
| ONLY error when i close the file with a macro that saves before closing.
|
| Is there a way i can prompt the user that the Workbook is currently Opened
| by "User Name, please try again later", then close the file after closing
| the msgbox.
|
| Corey....
|
|