Disable Macro on real only option
 

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

Disable Macro on real only option
 

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