Task: 

How to distribute workbooks including VBA without alert on opening? 

Solution: 

1. Copy the code to A:A of a sheet and delete all modules and class modules
2. Instruct user how to install it: "Copy A:A into an empty module"
3. This might be a 2-Level-Story: Tell user to start macro to install further code for modules and classes.

If you have a short example I will publish it here!

Generally, a similar operation is possible with Excel4 macros. They can not be copied into a normal sheet, neither into a Textbox directly. Copy them into a Windows Notepad window first, from there into a textbox in Excel. Note that names have to be redefined - perhaps by a macro managing this.