Recommended Read-Only Property

[Tim Childs]

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

 

[Rob Bovey]

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]

Bob

Many thanks for coming back on this

Tim

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 *