Check if file is open

[Macdave_19]

Is there a way of checking if a file is open and if so produing a message box to say so. i need to enusre thatonly 1 person at a time modifies a certain workbook (Data.xls)

Please please help!!!

[VBA Noob]

See if links helps

http://www.ozgrid.com/VBA/IsWorkbookOpen.htm

http://www.vbaexpress.com/kb/getarticle.php?kb_id=443

VBA Noob

[Richard Schollar]

The following link provides a way to determine if somebody else has the file open:

http://www.mrexcel.com/board2/viewto...430541#1430541

Richard