Losing VBA when emailing spreadsheet

[bclor3591]

Is there a way to send the VB code for buttons and macros with the spreadsheet when emailing from within excel? I have a button to send a spreadsheet through outlook, but when the file arrives at recipient the code and macro are not there.

 

[VBA Geek]

You want to email the whole workbook including its code? or just one worksheet of your workbook

 

[bclor3591]

Hello VBA Geek,

Yes, I'm trying to email 1 spreadsheet with 3 buttons (with the 2 macros and the VB code). The buttons work fine, but when I send the file the buttons show up with the data on the aspreadsheet, but the VB cose and macros doesn't go with the spreadsheet. I can send the code if you need it. I have to figure out how to attach VB code and macros to this post???

 

[VBA Geek]

The two buttons are Active X controls, command button? whereas the 3rd is in a standard module?

 

[bclor3591]

Under the Developer Tab, Actually, all 3 buttons are Active X Controls. Then I added a MODULE down at the Worksheet level and that is where I put the LESS DATA & MORE DATA macros. The VB code that has the CommandButton1-3 logic was added to the Sheet1 worksheet.

 

[VBA Geek]

if you use

thisworkbook.sheets("sheetToemail").copy

the new workbook will contain just this worksheet and the code at the worksheet level should be in there too

 

[bclor3591]

Hello VBA Geek,

I tried to add the code above to my code, but I'm not quite sure where it needs to go. I can send you the code for your review if I can figure out how to attach it to these posts?

 

[VBA Geek]

u can upload to zippyshare.com if not confidential