Modules does not run on another sys

March 1, 2009 at 22:14:49
Specs: Windows XP
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

See More: Modules does not run on another sys

Report •

March 1, 2009 at 23:21:23
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.

Report •
Related Solutions

Ask Question