I've written a macro that formats data then copies a range to an
email. It works fine when run from the VBE where I did all my
testing. When I moved it onto the end-users desktop and assigned a
shortcut key it stopped working properly. If run by way of the
shortcut key it runs through the first few lines of code and then
exits the macro completely.

It still works if I go to ToolsMacroRun

Set wbCurr = ActiveWorkbook
Set wsRaw = wbCurr.Worksheets(1)
sTempFilePath = "R:\CDR\Cust Serv\DailyStatsTemplate
\DailyStatsTemplate.xls"
Set wbTemplate = Workbooks.Open(sTempFilePath)

After opening the template workbook the macro ends completely.


I've never run into anything like this. Any help would be appreciated.

Remove the shiftkey from the shortcut combination and try it out.

Aviashn wrote:

I've written a macro that formats data then copies a range to an
email. It works fine when run from the VBE where I did all my
testing. When I moved it onto the end-users desktop and assigned a
shortcut key it stopped working properly. If run by way of the
shortcut key it runs through the first few lines of code and then
exits the macro completely.

It still works if I go to ToolsMacroRun

Set wbCurr = ActiveWorkbook
Set wsRaw = wbCurr.Worksheets(1)
sTempFilePath = "R:\CDR\Cust Serv\DailyStatsTemplate
\DailyStatsTemplate.xls"
Set wbTemplate = Workbooks.Open(sTempFilePath)

After opening the template workbook the macro ends completely.

I've never run into anything like this. Any help would be appreciated.

--

Dave Peterson

Thanks Dave, I'll give that a try.