When you save the code in your Personal.xls the other users do not have access
to the code.

Save the code in the workbook and your colleagues can use it.


Gord Dibben MS Excel MVP

On 26 Sep 2006 03:40:56 -0700, "Heine" wrote:

No, when I change my input data nothing happens. Is it due to the fact
that I saved it in my personal.xls?


CurlyDave wrote:
Can you use the code when you open the spreadsheet?

Heine wrote:
Hello,

I made a small code in VBA. But when my colleague open the spreadsheet
he can´t use my code. Where do I want to save my code, if I want
everybody to have access?

Thanks in advance