Two users simultaneously opening a spreadsheet

  • Thread starter Thread starter boe
  • Start date Start date
B

boe

Two users want to open a spreadsheet simultaneously. They are connected to
a Windows 2000 server. Sometimes they will get notice that it is already
open and it is read only. Sometimes they don't. How do we make sure they
get notification.

Thanks
 
This is what I ended up putting in my Workbook_Open event:

ActiveSheet.Select
If Me.ReadOnly Then
Result = MsgBox("Are you sure that you want to open this spreadsheet
in Read_only? You won't be able to save any changes that you make!",
vbCritical + vbApplicationModal + vbYesNo, "Read-Only Warning")
If Result = vbNo Then
Me.Close False
End If
End If
 
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

Migrate mailboxes from one Microsoft Exchange Server to another Exchange 1
Differences Between Two Spreadsheets ? 1
Excel nat saving Changes 2
Not getting read-only warning 6
Excel On A Shared Drive 2
Open User Form with spreadsheet 1
Can multiple users enter data into a spreadsheet simultaneously? 1
Excel issue saving files to hexadecimal filenames on terminal server... 1

Back
Top