Visual Basic code available for all open workbooks

I found the coding on the Pearson website for how to count cells based on the
color of the cell. WOW! That is just what I have been trying to figure out,
and it works perfectly.

I want to be able to access that coding no matter what workbook I open,
without having to copy the module from one workbook to another each time. I
tried saving it in my Personal Macro Workbook, but that didn't work.

Any suggestions?

What happened when it didn't work?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KristiB" <[email protected]> wrote in message
news:[email protected]...
> I found the coding on the Pearson website for how to count cells based on
the
> color of the cell. WOW! That is just what I have been trying to figure
out,
> and it works perfectly.
>
> I want to be able to access that coding no matter what workbook I open,
> without having to copy the module from one workbook to another each time.
I
> tried saving it in my Personal Macro Workbook, but that didn't work.
>
> Any suggestions?

I get a #NAME? error, so it is not recognizing the =countbycolor function in
the new workbook.

KB

"Bob Phillips" wrote:

> What happened when it didn't work?
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "KristiB" <[email protected]> wrote in message
> news:[email protected]...
> > I found the coding on the Pearson website for how to count cells based on
> the
> > color of the cell. WOW! That is just what I have been trying to figure
> out,
> > and it works perfectly.
> >
> > I want to be able to access that coding no matter what workbook I open,
> > without having to copy the module from one workbook to another each time.
> I
> > tried saving it in my Personal Macro Workbook, but that didn't work.
> >
> > Any suggestions?
>
>
>

try

=personal.xls!countybycolor(...

"KristiB" wrote:

> I get a #NAME? error, so it is not recognizing the =countbycolor function in
> the new workbook.
>
> KB
>
> "Bob Phillips" wrote:
>
> > What happened when it didn't work?
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "KristiB" <[email protected]> wrote in message
> > news:[email protected]...
> > > I found the coding on the Pearson website for how to count cells based on
> > the
> > > color of the cell. WOW! That is just what I have been trying to figure
> > out,
> > > and it works perfectly.
> > >
> > > I want to be able to access that coding no matter what workbook I open,
> > > without having to copy the module from one workbook to another each time.
> > I
> > > tried saving it in my Personal Macro Workbook, but that didn't work.
> > >
> > > Any suggestions?
> >
> >
> >

That worked!

Thanks bunches!

KB

"Duke Carey" wrote:

> try
>
> =personal.xls!countybycolor(...
>
> "KristiB" wrote:
>
> > I get a #NAME? error, so it is not recognizing the =countbycolor function in
> > the new workbook.
> >
> > KB
> >
> > "Bob Phillips" wrote:
> >
> > > What happened when it didn't work?
> > >
> > > --
> > >
> > > HTH
> > >
> > > RP
> > > (remove nothere from the email address if mailing direct)
> > >
> > >
> > > "KristiB" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I found the coding on the Pearson website for how to count cells based on
> > > the
> > > > color of the cell. WOW! That is just what I have been trying to figure
> > > out,
> > > > and it works perfectly.
> > > >
> > > > I want to be able to access that coding no matter what workbook I open,
> > > > without having to copy the module from one workbook to another each time.
> > > I
> > > > tried saving it in my Personal Macro Workbook, but that didn't work.
> > > >
> > > > Any suggestions?
> > >
> > >
> > >

Just adding to the others' posts, if you put the function in an
Add-In, you don't need to prefix the call with the workbook name.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"KristiB" <[email protected]> wrote in message
news:[email protected]...
>I found the coding on the Pearson website for how to count cells
>based on the
> color of the cell. WOW! That is just what I have been trying
> to figure out,
> and it works perfectly.
>
> I want to be able to access that coding no matter what workbook
> I open,
> without having to copy the module from one workbook to another
> each time. I
> tried saving it in my Personal Macro Workbook, but that didn't
> work.
>
> Any suggestions?