Testing of a workbook is in read only mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GLT - 24 Jan 2006 16:10 GMT

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.

Reply to this Message

Philip - 24 Jan 2006 16:39 GMT

Hi,

the test is:

if thisworkbook.ReadOnly = true then ...

OR

if workbooks(sName).readonly=true

HTH

Philip

> Hi,
>
[quoted text clipped - 6 lines]
> Thanks,
> GLT.

Reply to this Message