View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.office.developer.vba
Antunes Antunes is offline
external usenet poster
 
Posts: 1
Default 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.