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

If this is for personal use, you can add the .bas file to your persona
macro storage, and put a commandbutton on the excel menu. Just clic
the button to run the macro whenever you like

--
Message posted from http://www.ExcelForum.com

qu'est que-ce "personal macro storage"?

"dmang " wrote in message
...
If this is for personal use, you can add the .bas file to your personal
macro storage, and put a commandbutton on the excel menu. Just click
the button to run the macro whenever you like.


---
Message posted from http://www.ExcelForum.com/

I created a command button and pointed it to the .bas file, but when I
reopened a spreadsheet I wanted to apply the macro to and pressed the new
command button, I got:

"The macro 'Book1!BoldDuplicate' could not be found"

So how do I add it to the application itself (or is that even possible?)?


"dmang " wrote in message
...
If this is for personal use, you can add the .bas file to your personal
macro storage, and put a commandbutton on the excel menu. Just click
the button to run the macro whenever you like.


---
Message posted from http://www.ExcelForum.com/

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