How To Run Macro in HTML excel file

[johnjohns]

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

[royUK]

You cannot run VBa with a workbook saved as a web page

[johnjohns]

Thank you Roy, for the answer. I still hope microsoft will add this feature one day. It will be so helpful.

[royUK]

Thank you Roy, for the answer. I still hope microsoft will add this feature one day. It will be so helpful.

I doubt that they will