if activeworkbook.ReadOnly = true then
'do something
else
'do something else
end if

--


Gary Keramidas
Excel 2003


"Robert Crandal" wrote in message
...
If I open an Excel file which someone is currently using, Excel
will display a caption in the title bar that says "read only". Excel
is probably telling me that the file is read only because another
user currently is using the file.

My question is, does Excel have a function (or can I create
my own) which returns TRUE if the file is "read only" or
FALSE otherwise??? I'm mostly interested in a function
that returns TRUE if Excel displays the "read only" caption due
to the file's state of being in use.

thank you