Macro doesn't work with shortcut key

[domtrump]

I have a macro that copies a worksheet and pastes it into another workbook. If I run the macro using the developer tab on the ribbon, everything works fine. However, if I assign a shortcut key to it (ctrl-shift-k) then the macro starts to run but doesn't complete the copy & paste operation. Can anyone explain what is going on? Thanks.

Excel 2007:

Sub makedge()
'
' makedge Macro
' Copy Daily Worksheet to a new file for e-mail
'
    Sheets("Forecast Worksheet_Daily").Select
    Cells.Select
    Selection.Copy
    Workbooks.Open Filename:= _
        "S:\Financial Accounting\report2.xls"
    
    Cells.Select
    ActiveSheet.Paste
    ActiveWorkbook.BreakLink Name:= _
        "S:\Financial Accounting\report1.xls" _
        , Type:=xlExcelLinks
   
    Rows("94:101").Select
    Selection.EntireRow.Hidden = True
    
    Application.CutCopyMode = False
    Range("a2").Select
    ActiveWorkbook.Save
    
End Sub

 

[BrandonWLH]

http://www.mrexcel.com/forum/showthread.php?t=563010

check out this thread, very similar problem.

Thanks for your interest but I just figured it out. It's due to a bug in excel which is related to a conflict between using the 'open workbook' method and having the 'Shift' key pressed. In practical terms this means if your macro opens a workbook, you cannot have the Shift key as part of the keyboard shortcut to fire the macro. I simply changed the shortcut from 'Ctrl' + 'Shift' and 'J' to 'Ctrl' + 'J'.

 

[domtrump]

http://www.mrexcel.com/forum/showthread.php?t=563010

check out this thread, very similar problem.

Thank you! This was driving me nuts. Ctrl-k works fine.

-Dom

 

[AltNrg4U]

This was very helpful. It is always maddening to try and solve and issue, when no issue really exists (software bugs).
I did want to mention that my "Shift" shortcut works just fine. It was when I copied this large workbook and modified it, that the macro ceased to work. When I removed the "Shift" from my macro, now the modified workbook works.

Thanks for the research!