W
Wandering Mage
Is there a way to make it so that only one person can have
the workbook open at a time?
the workbook open at a time?
G
Grey Newt
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
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
F
Frank Kabel
Hi
another problem with a VBA solution is that the user can simply disable
macros and your workbook will just open
another problem with a VBA solution is that the user can simply disable
macros and your workbook will just open
G
Grey Newt
Very true :-(
Frank Kabel said:Hi
another problem with a VBA solution is that the user can simply disable
macros and your workbook will just open