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
|