Bob

Many thanks for coming back on this

Tim


"Rob Bovey" wrote in message
...
Hi Tim,

If ActiveWorkbook.ReadOnlyRecommended Then
''' It's read-only recommended.
End If

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Tim Childs" wrote in message
...
Hi

Can someone give me the code snippet for determining if a workbook has
the
"switch" for recommending the user to open the file in read-only mode?

THANKS

Tim