Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to determine an opened sheet( Read Only)
Hi,
when someone opens a workbook which already was opened by someone else, the person gets a dialogbox, inwhich (s)he can select 'read only'. But when the user opens the workbook through a script, the user is not warned. I want to stop the script if the opened workbook was already opened by someone else. How do I determine this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to determine an opened sheet( Read Only)
http://support.microsoft.com?kbid=138621
XL: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=291295 XL2002: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=213383 XL2000: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=184982 WD97: VBA Function to Check If File or Document Is Open -- Regards, Tom Ogilvy "TTD" wrote in message et... Hi, when someone opens a workbook which already was opened by someone else, the person gets a dialogbox, inwhich (s)he can select 'read only'. But when the user opens the workbook through a script, the user is not warned. I want to stop the script if the opened workbook was already opened by someone else. How do I determine this? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to determine an opened sheet( Read Only)
Thanks Tom.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limit to number of opened Read Onlys | Excel Discussion (Misc queries) | |||
how do i determine when a file was last opened | Excel Discussion (Misc queries) | |||
Rules that act on messages after they are opened & read? | Excel Discussion (Misc queries) | |||
How to determine if Workbook has been opened exclusively | Excel Programming | |||
How to read sheet of currently opened workbook | Excel Programming |