It concluded with the ability for the administrator of the file in your comapny's intranet creating a new workbook with the macro I posted, to delete all code out of the subject workbook, and send that to the final destination user, unless, as Isaid then the code removal is done manually by said admin if this is a one time deal.hon said:Last night, our discussion led to the conclusion that it is impossible to remove the macro on filesave as it depends on the user turning on the macro in the first place.
If that means, impossible to enable another user's macro securtty settings, then your conclusion is correct, it's impossible.hon said:Today, I concluded that it is impossible to force users to turn on the macro.
If you mean, somehow delete the code in the workbook if the user does not enable macros, the answer is no, since it would require automation to do so that is disallowed at that point by the user. As you have seen, there is a way to tell the user the consequences of not enabling their macros, because now they won't get the benefit of the coded enhancements, but you cannot force them to do anything or make the workbook "not load code" if the local settings do not allow for macro execution.hon said:But my last question is 'Is it possible not to load macro when a user chooses not to turn on the macro?' (by some form of setting I was hoping). I guess it is not possible either
hon said:Just want to find out if it is possible to force Excel to turn on macro when open.