[SOLVED] Testing of a workbook is in read only mode

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.

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.