Is there a way to have the default workbook to open a macro?

What I am wanting to do is to make a change to Excel that would load a macro
to delete hyperlinks (cells.hyperlinks.delete) that'd load when I opened
excel, so all I'd have to do after pasting a web page into excel is to run
that macro.

Have not found a way to do this without a lot of trouble, and would need to
have a method of letting less-than-expert users be able to do this easily.
I was thinking that making excel load this macro on open would be the best
way to do it.

SC