gads.... you gotta love it.
It works!
And, I was even able to set up my own "autofill" macro for my ribbon, and
that works too....
Thank you bery, bery, bery much!


"Gord Dibben" wrote:

Yes, you can access UDF's and macros directly through an Add-in....Excel 2007
XLAM in your case.


Gord

On Mon, 10 Dec 2007 11:18:01 -0800, SteveDB1
wrote:

Gord,
So, if I get this correctly, you're saying that we can place the UDF's-- in
general-- in an XLAM workbook, and then add them to our add-in lists, and
access them through that?


"Gord Dibben" wrote:

Or put the functions in a new workbook and save as an Add-in.

Load through ToolsAdd-ins and you won't have to preface the UDF with the
filename.

=SumByColor(A1:A10) will suffice.


Gord Dibben MS Excel MVP


On Mon, 10 Dec 2007 09:44:00 -0800, SteveDB1
wrote:

April,
with this function you need to use the following "preface" to access the
macro.
in your worksheet cell write hte following:
=worksheetname!sumbycolor(range,colornumber,... )
Part of hte problem you've encountered is that you're accessing a function
that's stored in another workbook, and it does not call to that workbook
UNLESS you state it.
I place all of my macros in a single workbook-- personal.xlsb, so when I
call to that function I write hte following:
=personal.xlsb!SumByColor(.......)
It'll work if you choose that.
Best.

"april" wrote:

i have copied the code from cpearson.com/excel/colors.htm which allows you to
sum a range of cells by color. this worked fine in one spreadsheet but when
i copied the same code to another spreadsheet i get a NAME? error. any
suggestions?

thank you
--
aprilshowers