Difficulty for assigning shortcut key for a macro

[ANKUSHRS1]

Hi,

Please help me to get rid of this problem.

I want to assign a key for a macro...I have assigned such keys function my previous macro but Now I am facing the problem..

maybe this is location or scope of macro or variables....i cant figure it out..pls help

 

[Hui]

Click on the The Workbook module
Then add a sub

Private Sub Workbook_Open()
   Application.onkey "+(F10)", "Add"
End Sub

Save the file and re-open it

 

[ANKUSHRS1]

Click on the The Workbook module
Then add a sub

Private Sub Workbook_Open()
   Application.onkey "+(F10)", "Add"
End Sub

Save the file and re-open it

Thanks....