How To Run Macro in HTML excel file

Hi

I have wriiten a macro in excel that pops up some photos whenever the respective cell is selected. It is working good except when I save the file in HTML format. Can somebody help? Also what is the difference between publishing and saving html file?

I am using office 2003 and microsoft web components installed

rgds

John Johns