How to save my VBA-code

H

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
 
H

Heine

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

Don Guillett

Save it in the workbook you gave to your friend

--
Don Guillett
SalesAid Software
[email protected]
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
 
G

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
 
Top