| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is Workbook read-only because of file permission or because file is already opened?
Hi,
When someone opens my Excel workbook, I want to trap with VBA code wether or not the file is read-only. Then, I want to do different operations based on the cause of the read-only : file permissions are read-only (or user does not have write permissions), or another user already opened the file. Is there a way to do such a distinction ? Thank you very much in advance, Alexis |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook has [Group] at the end of teh file name when opened | New Users to Excel | |||
| How do I clear read-only status on a workbook file? | Excel Discussion (Misc queries) | |||
| Excel file opened as read-only, if saved by another user | Excel Discussion (Misc queries) | |||
| How set file open path to filepath of file opened with Explorer ? | Excel Programming | |||
| How to read sheet of currently opened workbook | Excel Programming | |||
Linear Mode
