aymenelking

Dear Friends,

I need urgunt help please.

I have a macro which i wrote in the excel sheet,
i need some way to save this macro alone<separate from the excel sheet> and a way to insert that macro to the data sheet , i don't want to put the macro in th excel file internaly but want to use the macro and the execl sheet separate, thanks to advise

aymenelking

I need a way to save the macro as an external file from the excel sheet , and a way to run this external macro file from the excel sheet.

Thanks for yr assistance.

shg

Put the macro in an add-in. See http://www.fontstuff.com/VBA/vbatut03.htm