| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Detection of Workbook already Open
I have a workbook that runs on a network and wish to
intercept if any user has the file open. At the moment the standard Excel message appears with the option to open it read only etc. My intention is prevent users from doing anything if the workbook is already open, display a message to this effect and then close the file. TIA Nigel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to: Open closed workbook/Search data tables/Return data to open workbook | Excel Discussion (Misc queries) | |||
| how do i open a data workbook when i open a timesheet workbook | Excel Discussion (Misc queries) | |||
| Directory and File Detection | Excel Discussion (Misc queries) | |||
| Color detection | Excel Worksheet Functions | |||
| Detection of VBA code | Excel Programming | |||
![Nigel[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
