Only one user @ a time?

  • Thread starter Thread starter Wandering Mage
  • Start date Start date
W

Wandering Mage

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
 
Hi
another problem with a VBA solution is that the user can simply disable
macros and your workbook will just open :-)
 
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 :-)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unwanted workbooks on startup 2
Share a document 1
Excel Protection 2
VBA and SharePoint permissions 3
Using the OnTimer event to lock out users between specific time window. 12
Close Referenced Workbook if it's No Longer Referenced 4
Why is file suddenly "Read Only"? 3
MsgBox that will open only once. 24

Back
Top