Macros functionality

[Nabeel Alkasasbeh]

I have one sheet with many macros, due to security reason, I have to disable all macros and send it through email but when email receiver open the sheet and tried to run macros it did not work even if he enable macros, is there any way to return the functionality to all macros without remaking it all again.  

[#2]

If you disable macros by saving the file in .xlsx format then all VBA code will be removed from the file.  The restriction on sending macro enabled files is likely a network security setting which you could confirm with your network System Administrator.  These settings are often implemented by restricting attachments based on their file extensions rather than inspecting the actual attachment contents.  You could test this by trying to send a blank .xlsm file containing no macros and see if it is rejected.  If it is, then try saving and sending as .xlsb file.  

[#3]

not always, but simple zip of the file could work