change active userform setting before attaching workbook.

[SierraKilo78]

Hi, need some help here. Been breaking me head trying few tricks but no luck.

I have a userform that ive set to show when the excel file is clicked to open keeping the workbook visible property as false. This userform has a send button that is to email and attach the workbook to some emailz defined in code.




What I was looking if possible is the reverse action. That is when the recipients gets the email, they do not see the userform and instead see one of the sheets when they open the attachment.

If is possible that the setting changes before attaching the excelsheet?

Any help would be greatly appreciated

[davesexcel]

You can make a copy of the worksheet into another workbook, then email it from there.

Please Login or Register  to view this content.