cancelling copy command after reactivating workbook

P

PattiP

I have a range on a worksheet that will be getting emailed to the same
company frequently. I currently have the following code to copy the range so
the user can just paste it into the email and just hit "send":

ThisWorkbook.Worksheets("Schedule Sheet").Range("LMPLAN").Copy

Upon returning to the worksheet, I would like the blinking copy command to
automatically go away.

I'm thinking I need to write something like this:

If ThisWorkbook.activate = True,
then Application.CutCopyMode = False

But that evidentally isn't the proper code. What would be the proper way to
write this code?

Also, is there any way to add code to automatically open our email (We use
Lotus Notes) so the user can just paste the data?

Thanks!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top