I have made a module as time,calender in excel. It runs smoothly on my system But when Transfer file or save file on another system. It requires to setting as Tool-security etc. Plz help me to run modules & Macro whereas we can run desired system thansk with regards Saroj Kumar singh

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.