How to make a function accessible for all workbooks

Hi---How can I make this functoin accessible to all workbooks...

Function coloring(cell)
'
' coloring Macro
' Macro recorded 11.05.2005 by AABULABAN
'
coloring = cell.Interior.ColorIndex

End Function

I have it saved under the Personal workbook, however, it only works
there and no where else. Please help. Thanks

If you are calling it from a worksheet cell, you need to include
the workbook name in the call. E.g.,

=personal.xls!coloring(A1)


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



"Mark the Shark" <aabulaban@hotmail.com> wrote in message
news:96eea73e.0505110354.7b31dbcd@posting.google.com...
> Hi---How can I make this functoin accessible to all
> workbooks...
>
> Function coloring(cell)
> '
> ' coloring Macro
> ' Macro recorded 11.05.2005 by AABULABAN
> '
> coloring = cell.Interior.ColorIndex
>
> End Function
>
> I have it saved under the Personal workbook, however, it only
> works
> there and no where else. Please help. Thanks

Thanks a lot...this was very helpful!!!

*** Sent via Developersdex http://www.developersdex.com ***