Cannot insert module in excel to run a macro-option greyed out

[pri3257]

I have a user who needs to turn all hyperlinks in a spreadsheet into text. I have a macro for him to run.

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Directions

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run

This works fine for me

I had him try and when he clicks Insert, all the commands including module are greyed out. I have tried logging in with a non admin user and also changing macro security. Neither have enabled the use of insert macro. Does anyone know how to enable this, or another way of doing this process?

Thanks

 

[combo]

Is the workbook shared? - you can't edit vba project in this mode.
What is the message when you try to view vbaproject in VBE project explorer?
Can you insert module in word, powerpoint?
What is the office version?

combo