Macros

Hi Sunil, Thank you for the post, In answer to your question, rather than trying to export the macro to different workbooks you should save the macro to the Personal Macro Workbook which will make it available to all workbooks opened on that computer. Hope that helps, best regards Pete

Hi Sunil, Thank you for the post, In answer to your question, rather than trying to export the macro to different workbooks you should save the macro to the Personal Macro Workbook which will make it available to all workbooks opened on that computer. Hope that helps, best regards Pete