import your .bas file into a new workbook.

Save that workbook in your XLStart folder and it'll load each time excel starts.

(Lots of people name workbooks that hold their favorite macros personal.xls.)

Then use tools|macros|macro...
select your macro and Run.
When you need to run it.

Joe Murphy wrote:

I have a .bas file that I use to bold duplicate occurrences in a column.
Works great, but everytime I open a new spreadsheet I have to go to Tools
Macros VB Editor and then File Import File and go find the .bas file.

Is there a way for this .bas file to be loaded into Excel at startup?

Thanks,
JM

--

Dave Peterson