How to save my VBA-code

[Heine]

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

 

[CurlyDave]

Can you use the code when you open the spreadsheet?

 

[Heine]

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

 

[Don Guillett]

Save it in the workbook you gave to your friend

--
Don Guillett
SalesAid Software
(e-mail address removed)
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

 

[Gord Dibben]

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