More likely I was - I was assuming that the user would be switching
between sheets.

You could add this to the ThisWorkbook module:

Private Sub Workbook_Open()
If ActiveSheet.Name = "Sheet1" Then _
Application.OnKey "^c", "SpecialCopy"
End Sub

Private Sub Workbook_Activate()
If ActiveSheet.Name = "Sheet1" Then _
Application.OnKey "^c", "SpecialCopy"
End Sub

Private Sub Workbook_Deactivate()
Application.OnKey "^c"
End Sub


Which would fire the code that changes the keyboard shortcut when the
workbook is opened or switched back to from another workbook.


In article ,
sudhiramin wrote:

I have tried with this code and nothing seems to be working right. Maybe i
am missing out on something.