Only one user @ a time?
Is there a way to make it so that only one person can have
the workbook open at a time? |
Only one user @ 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? |
Only one user @ 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? |
Only one user @ 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? |
All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com