Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to see if the opened workbook is opened by another user ?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to see if the opened workbook is opened by another user ?
Hi,
The file should be in readOnly mode. This is what you have to check If ActiveWorkbook.ReadOnly = true Then Regards, JY "balexis" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula not working when opened by another user | Excel Discussion (Misc queries) | |||
Need to Query Excel File Opened by Another User | Excel Discussion (Misc queries) | |||
Shared spreadsheet changes color when opened ny another user. Why | Excel Worksheet Functions | |||
Shared spreadsheet changes color when opened ny another user. Why | Excel Worksheet Functions | |||
Spreadsheet opened by user or programme | Excel Programming |