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