After running an email macro other macros will not work.

**dynamicexcel** · 12-28-2012, 02:06 PM

Greetings,

I am new to VBA and macros so there might be simple fix to this problem. I have a macro that creates an email from the active sheet. Everything works fine and the macro performs flawlessly, however as soon as it is finished none of the other macros or objects (checkboxes) on the sheet work until you click in a cell. Then everything seems to reset and work fine again. I would like people to be able to email the sheet and then come right back to it and be able to use the print button without having to click anywhere else.
I did try to set the focus at the end back to one of the cells but that didn't seem to work either.

Here is the code for reference:

Please Login or Register  to view this content.

Any help is greatly appreciated. Thanks!

**Richard Buttrey** · 12-28-2012, 02:20 PM

Hi,

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

**dynamicexcel** · 12-28-2012, 02:28 PM

Understood, I will be sure to attach in future. Thanks for the info

See attached.

**Richard Buttrey** · 12-28-2012, 05:54 PM

Hi,

I'm struggling to replicate your apparent problem.

Out of the box on my laptop I can click the eMail to QC button which creates the email. Jumping back into Excel I can immediately click the Print button or select any of the checkbox objects without any problem.

If I add the line 'Range("AL2").Select' as the last instruction then AL2 is made the active cell.

Are you saying that after clicking the eMail button you then can't click the Print button?

**dynamicexcel** · 12-29-2012, 05:37 PM

Hi,

I tried it again and it still behaves the same as before. The one difference in reproducing the problem might be that the sheet I uploaded is unprotected. When the sheet is deployed it will be protected with only allowing users to select unlocked cells. I have been running it with protection. Thanks so much for your response.

**Richard Buttrey** · 12-29-2012, 06:42 PM

Hi,

I've just protected the workbook to test this and still don't encounter any problems.

Which version of Excel are you using? Your profile says 2012 although I'm not aware there is such a version. The latest production versions are Excel for Windows 2010 (2013 has still not been released) and Excel for Mac is 2011.