|You cannot force a macro to run on another system. Think about the security implications if you could. You could write malicious code and destroy another person's system. Only the user him/her self can choose to enable macros on their own machine.|
The common practice is to include code in the workbook that hides all sheets except for an instruction sheet upon closing. You also include code that hides the instruction sheet and unhides all the other sheets upon opening. If macros are not enabled, the user will only see the instruction sheet upon opening.
On the instruction sheet you let the users know that if they don't enable macros and then close and reopen the workbook, they can't use it.