VBA Code to Know Macro Enable or Disable when Open workbook

Hello all,

My problem is that I need to prevent from another person who try to copy my worksheet to use with other computer without authorization from me.
Thus, I tried to wirte coding for closing my workbook when it is used with other unathorized computer but in order to run this script, I need to enable macro at all the time my workbook open.

As my idea, I have to write coding for checking excel whether Macro enable or disable when we are open it. If Macro disable, workbook must be closed automatically. (I tried to write this code but it is impossible).

Is any one have ideas to help me?

Thanks in advance for sharing your ideas.

David,

Thank TMS for your advice.

Yes, as you said "Anyone with an interest in Excel and VBA, and access to the Internet, will be able to remove or work around most protection".

That is what I concern about.

Is there any more of comments?

Thanks!

How about storing you macros in you personal workbook?

http://chandoo.org/wp/2013/11/18/usi...acro-workbook/

Alf