View Single Post
  #3   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Fries,

Also, functions stored in an Addin can be accesed like native functions.

---
Regards,
Norman



"Fries" wrote in message
ups.com...
Hello,

I made (copied) a function that returns the Index of the background of
a cell.

I saved it in a module in my Personal.xls workbook.

Having done that, I thought IŽd be able to use it like:
=GetColorIndex(B5)

But... I have to use it like: =Personal.xls!GetColorIndex(B5)

Is there a way to achieve the first option, simply =GetColorIndex(B5)
without the Personal.xls! part before the function?

thanks,

Fries