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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cizzo - 27 Nov 2007 15:59 GMT

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.

Reply to this Message

Gord Dibben - 27 Nov 2007 16:53 GMT

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

>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.

Reply to this Message

Rate this thread: