| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want "locked for editing" message
I like the message that says
Wbook.xls is locked for editing by 'Username' Click 'Notify' to open a read-only copy of the document and receive notification when the document is no longer in use. But if I open a workbook via Workbooks.Open Filename:="Wbook.xls" ...it just opens Read-only, which is not what I want. Can I get VBA to do this, so the user would be notified? I could duplicate the text in VBA, but it wouldn't notify anybody. Dan Williams danwPlanet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Locked for Editing" error on a non-protected file | Excel Discussion (Misc queries) | |||
| "Locked for Editing" problem in Excel 2007 | Excel Discussion (Misc queries) | |||
| Getting message: ".xls is locked for editing by ------" | Excel Discussion (Misc queries) | |||
| Prevent "XYZ.doc is locked for editing" message | Excel Programming | |||
| Not getting "Locked for Editing" message | Excel Discussion (Misc queries) | |||
Threaded Mode
