Deploy Excel Macros
1.st, you can compilate all your macros in a single Excel file and than
save the file as *.xla, than in the new PC you jast have to run the XLA
file.
2.nd, to protect your code, you have to go to the VBA window (Alt +
F11) and in the menu go to - Tools - VBAProject Properties... -
Protection - here you can look the project for viewing and put a
password.
|