ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   hide vba code (https://www.excelbanter.com/excel-programming/398197-hide-vba-code.html)

geebee

hide vba code
 
hi,

i would like to know if there is a way i can hide the code in a spreadsheet
after i pass it along. and will the code still work if it is hidden?

thanks in advance,
geebee


Dave Peterson

hide vba code
 
Inside the VBE
Select your workbook's project
tools|VBAProject Properties|Protection tab

Lock it for viewing and give it a memorable password.

Be aware that this password isn't going to stop the really dedicated--but it
will keep most people out.

geebee wrote:

hi,

i would like to know if there is a way i can hide the code in a spreadsheet
after i pass it along. and will the code still work if it is hidden?

thanks in advance,
geebee


--

Dave Peterson


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com