Macro Button

jacob10_2000 · May 22nd, 2002, 12:55 PM

I have a situation at work, where I receive an excel spreadsheet every week and I need to customize it. I have written a macro to do all the customizing for me, but it is linked to the spreadsheet, with which it was created. How do I link it to a macro button in a tool bar, which will work on whatever workbook is open. Thanks for any help you can provide

cornbread · May 22nd, 2002, 01:07 PM

export the module and import it into your new workbook when you recieve it.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 12:55 PM	#1
jacob10_2000 New Member Join Date: May 2002 Location: north smithfield, ri Posts: 1	I have a situation at work, where I receive an excel spreadsheet every week and I need to customize it. I have written a macro to do all the customizing for me, but it is linked to the spreadsheet, with which it was created. How do I link it to a macro button in a tool bar, which will work on whatever workbook is open. Thanks for any help you can provide

May 22nd, 2002, 01:07 PM	#2
cornbread Board Regular Join Date: Apr 2002 Location: Oregon Posts: 77	export the module and import it into your new workbook when you recieve it.