How to add a macro (.bas) file in Excel?

[cizzo]

I am running Excel 2003. I need to import a .bas file as a button so
that it can be used on all worksheets/books. I am aware of the visual
basic editor and importing a file, but what do I do from there.

Thank you in advance.

 

[Gord Dibben]

If you want the macro to be available for all workbooks, with Personal.xls open
go to the VBE and select Personal.xls and import the *.bas file to that
workbook.

Or create a new workbook, import the *.bas file then save the new file as an
Add-in which can be loaded through Tools>Add-ins.

Assign the macro to a button, either on a Toolbar or on a sheet.


Gord Dibben MS Excel MVP