Disable Macro on real only option

[Renato8]

Hi, I want to know how can I disable a macro if the workbook is open in read only option, because I dont want that someone execute a macro that changes cant be save after.


Thanks

Renato

[Tom Ogilvy]

easier might be to have your macro check the status and just quit if the
workbook is read only.

if activeworkbook.ReadOnly then exit sub

or if the macro is in the workbook

if thisworkbook.ReadOnly then exit sub

--
Regards,
Tom Ogilvy


"Renato8" wrote:

>
> Hi, I want to know how can I disable a macro if the workbook is open in
> read only option, because I dont want that someone execute a macro that
> changes cant be save after.
>
>
> Thanks
>
> Renato
>
>
> --
> Renato8
> ------------------------------------------------------------------------
> Renato8's Profile: http://www.excelforum.com/member.php...o&userid=30604
> View this thread: http://www.excelforum.com/showthread...hreadid=537275
>
>