ISERROR appearing in Excel 2007 shortcut key macro?

[malfane]

First, my disclaimer is that I am not familiar with Excel or VB :(

That being said, one of my users is getting an error when running a macro in Excel 2007 from his personal.xlsm.

The macro is a simple color change which we have re-recorded several times but when he attempts to run the macro with a shortcut key the field populates with =IF(ISERROR(100),"NA",100) where 100 was the test value of the original cell. If you run the macro from the menu it works correctly.

Macro is:

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+Shift+E
'
With Selection.Font
.Color = -4165632
.TintAndShade = 0
End With
End Sub

Any suggestions are greatly appreciated.

Thanks!