How to see if the opened workbook is opened by another user ?

  • Thread starter Thread starter balexis
  • Start date Start date
B

balexis

Hi,

I want to restrict the use of an Excel application to just one user at
a time. Basically, my application is composed of a few protected
sheets (user must not change the cells manually), and a toolbar with
macros associated.

I only want 1 user to be able to have to execute macros at the same
time. I would like to gray all the toolbar's buttons when the excel
file is already opened by another user.

Now, how can I detect that the excel file is already opened by another
user with vba code ?

Thank you for your help in advance,


Alex
 
Hi,

The file should be in readOnly mode.
This is what you have to check
If ActiveWorkbook.ReadOnly = true Then
Regards,

JY
 
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

Determine if workbook is open 2
Excel is removing Macros from workbook 3
How to Unlock Excel Workbook protected by MACRO Password 6
Events won't trigger if locked for edit and if opened from IE 4
Open Word file with Excel VBA 2
code to open another workbook 3
Detecting open workbook 2
Open Workbook Macro - with a twist 1

Back
Top