Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save-As Option Disable | Excel Worksheet Functions | |||
Disable Option in Como Box | Excel Programming | |||
How to disable smoothline option. | Charts and Charting in Excel | |||
Disable "Save As" Option | Excel Discussion (Misc queries) | |||
Disable Macro Option | Excel Programming |