Macro Code to Check Whether a File Is Already Open (138621)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel 98 Macintosh Edition
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q138621 For a Microsoft Excel 2002 version of this article, see 291295.
For a Microsoft Excel 2000 version of this article, see 213383.
SUMMARY
The following Microsoft Visual Basic for Applications procedure is an
example of how to determine if another user has a file open. This type of
macro is useful if you are using a file that is shared over a network
where only one user at a time should open the file.
Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
---|
Keywords: | kbdtacode kbhowto kbProgramming KB138621 |
---|
|