| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling disable macros
Hi,
I wrote macros in my excel sheet. If user clicks on disable macro, my excel sheet should not be opened. Any help. Regards, Ram |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling disable macros
most usual solution
have one extra sheet that declares loudly "MACROS MUST BE ENABLED FOR THIS WORKBOOK TO RUN." and your other worksheets hidden. If they click enble macros use code to have that sheet hidden and all other appear. but if they click disable only that sheet is visible. Be sure to reverse the process on save or close. Ben -- When you lose your mind, you free your life. "Ram" wrote: Hi, I wrote macros in my excel sheet. If user clicks on disable macro, my excel sheet should not be opened. Any help. Regards, Ram |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling disable macros
Hi Ben,
Thank you very much. But when i make the sheets visible, user can save the EXCEL and he will have a copy of visible sheets. Thanks and Regards, Ram "ben" wrote: most usual solution have one extra sheet that declares loudly "MACROS MUST BE ENABLED FOR THIS WORKBOOK TO RUN." and your other worksheets hidden. If they click enble macros use code to have that sheet hidden and all other appear. but if they click disable only that sheet is visible. Be sure to reverse the process on save or close. Ben -- When you lose your mind, you free your life. "Ram" wrote: Hi, I wrote macros in my excel sheet. If user clicks on disable macro, my excel sheet should not be opened. Any help. Regards, Ram |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling disable macros
you can add code to the
sub workbook_beforesave(byval cancel as boolean) 'make sheets invisible here again. end sub put that in your workbook module -- When you lose your mind, you free your life. "Ram" wrote: Hi Ben, Thank you very much. But when i make the sheets visible, user can save the EXCEL and he will have a copy of visible sheets. Thanks and Regards, Ram "ben" wrote: most usual solution have one extra sheet that declares loudly "MACROS MUST BE ENABLED FOR THIS WORKBOOK TO RUN." and your other worksheets hidden. If they click enble macros use code to have that sheet hidden and all other appear. but if they click disable only that sheet is visible. Be sure to reverse the process on save or close. Ben -- When you lose your mind, you free your life. "Ram" wrote: Hi, I wrote macros in my excel sheet. If user clicks on disable macro, my excel sheet should not be opened. Any help. Regards, Ram |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling disable macros
Hi Ben,
Thanks . It works. Regards, Ram "ben" wrote: you can add code to the sub workbook_beforesave(byval cancel as boolean) 'make sheets invisible here again. end sub put that in your workbook module -- When you lose your mind, you free your life. "Ram" wrote: Hi Ben, Thank you very much. But when i make the sheets visible, user can save the EXCEL and he will have a copy of visible sheets. Thanks and Regards, Ram "ben" wrote: most usual solution have one extra sheet that declares loudly "MACROS MUST BE ENABLED FOR THIS WORKBOOK TO RUN." and your other worksheets hidden. If they click enble macros use code to have that sheet hidden and all other appear. but if they click disable only that sheet is visible. Be sure to reverse the process on save or close. Ben -- When you lose your mind, you free your life. "Ram" wrote: Hi, I wrote macros in my excel sheet. If user clicks on disable macro, my excel sheet should not be opened. Any help. Regards, Ram |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disabling disable macros
sub workbook_beforesave(byval cancel as boolean)
That code won't compile, because it doesn't match teh BeforeSave declaration. Use Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) instead. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ben" (remove this if mailing direct) wrote in message ... you can add code to the sub workbook_beforesave(byval cancel as boolean) 'make sheets invisible here again. end sub put that in your workbook module -- When you lose your mind, you free your life. "Ram" wrote: Hi Ben, Thank you very much. But when i make the sheets visible, user can save the EXCEL and he will have a copy of visible sheets. Thanks and Regards, Ram "ben" wrote: most usual solution have one extra sheet that declares loudly "MACROS MUST BE ENABLED FOR THIS WORKBOOK TO RUN." and your other worksheets hidden. If they click enble macros use code to have that sheet hidden and all other appear. but if they click disable only that sheet is visible. Be sure to reverse the process on save or close. Ben -- When you lose your mind, you free your life. "Ram" wrote: Hi, I wrote macros in my excel sheet. If user clicks on disable macro, my excel sheet should not be opened. Any help. Regards, Ram |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disabling macros | Excel Discussion (Misc queries) | |||
| Disabling Macros | Excel Programming | |||
| Disabling Macros | Excel Programming | |||
| Disabling/Enabling Macros | Excel Programming | |||
| Disabling the enable/disable dialog box with Digital Signature | Excel Programming | |||
Linear Mode
