Macro error message keeps popping up

[daniels012]

I have enabled macros on a spreadsheet I have created.
I am using Windows 7 and office 7
I have created the spreadsheet in compatibility mode so I can use it on my computer at home.
I have created a shortcut macro to paste values quickly.

I get a message that says something to the fact; you need to enable macros. close your sheet and reopen and enable macros. I go to the trust center and I have allow all macros.

I can right click my tab and view code and manually run the macro and it works fine.
Any idea what might me my issue?
Thank You in advance!
Michael

 

[daniels012]

bump