Is there a way to make it so that only one person can have
the workbook open at a time?

When a second person opens the workbook, it is opened read-only. You can look for this property in a workbook open event - and if true - close the workbook immediately.
It won't stop someone from making a copy and opening it independantly though - you'll have to use login code or registry code to stop this

"Wandering Mage" wrote:

Is there a way to make it so that only one person can have
the workbook open at a time?

Hi
another problem with a VBA solution is that the user can simply disable
macros and your workbook will just open :-)

--
Regards
Frank Kabel
Frankfurt, Germany


Grey Newt wrote:
When a second person opens the workbook, it is opened read-only. You
can look for this property in a workbook open event - and if true -
close the workbook immediately. It won't stop someone from making a
copy and opening it independantly though - you'll have to use login
code or registry code to stop this

"Wandering Mage" wrote:

Is there a way to make it so that only one person can have
the workbook open at a time?

Very true :-(

"Frank Kabel" wrote:

Hi
another problem with a VBA solution is that the user can simply disable
macros and your workbook will just open :-)

--
Regards
Frank Kabel
Frankfurt, Germany


Grey Newt wrote:
When a second person opens the workbook, it is opened read-only. You
can look for this property in a workbook open event - and if true -
close the workbook immediately. It won't stop someone from making a
copy and opening it independantly though - you'll have to use login
code or registry code to stop this

"Wandering Mage" wrote:

Is there a way to make it so that only one person can have
the workbook open at a time?