ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   remove vba code before emailing as attachment (https://www.excelbanter.com/excel-programming/407589-remove-vba-code-before-emailing-attachment.html)

pswanie

remove vba code before emailing as attachment
 
i got a code of ron thats working fine to email my workbook.

what i would like to do now is to remove two form buttons on sheet named
"products" and i got module1 and module2 that needs to be removed....


thanx

Phillip

Ron de Bruin

remove vba code before emailing as attachment
 
Hi pswanie

If you install my mail add-in you have this option
http://www.rondebruin.nl/mail/add-in.htm

If you want to use code see Chip Pearson's page
http://www.cpearson.com/excel/vbe.aspx


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pswanie" wrote in message ...
i got a code of ron thats working fine to email my workbook.

what i would like to do now is to remove two form buttons on sheet named
"products" and i got module1 and module2 that needs to be removed....


thanx

Phillip



All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com