Hi,

the test is:

if thisworkbook.ReadOnly = true then ...

OR

if workbooks(sName).readonly=true

HTH

Philip

"GLT" wrote:

Hi,

I have three macros in my workbook however I only want these macros to be
allowed to run if the workbook is protected by being read-only.

This would mean if any of the macros run then it would check to see the
status of the workbook first - could anyone advise how to acheive this?

Thanks,
GLT.