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.
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???
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.