Visual Basic code available for all open workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
I get a #NAME? error, so it is not recognizing the =countbycolor function in
the new workbook.

KB
 
try

=personal.xls!countybycolor(...

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

KB
Click to expand...
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SEQUENTIAL NUMBERING OF WORKBOOKS 1
Im doing something wrong in Visual basic for sure 3
Cross referencing two workbooks? 3
Visual Basic Code Remains in "memory" 1
problem with linked workbook 1
move worksheet to end of another workbook 3
XL2000 Links Between Workbooks 2
Custom Functions Available for all Workbooks 2

Back
Top