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

How to make a function accessible for all workbooks
 

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" wrote in message
om...
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

How to make a function accessible for all workbooks
 

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

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