In Excel, press Alt-F11 to open the VBIDE. Right click on the module names to remove or export them, before emailing the workbook. –JP
To disable macros, click ‘Tools’ – ‘Options.’ When the ‘Options’ dialog box appears, click the ‘Security’ tab. Click ‘Macro Security. In the ‘Security’ dialog box , select the ‘Security level’ tab. Here you can set the macro security level to low, medium, high or very high. Under the “Very High” setting, only macros installed in trusted locations will be allowed to run. All other signed and unsigned macros are disabled. You can disable all macros entirely by setting your security level to Very High and disabling macros installed in trusted locations. To disable macros installed in trusted locations, click Tools, then select Macro and Security, and then click on the Trusted Publisher tab and “uncheck” the Trust all installed add-ins and templates option.