Hello.
Just wondering does anyone know how to hide the VBA editor, so that others could not gain access to the VBA editor to view the coding?
Thanks.
Regards
Hello.
Just wondering does anyone know how to hide the VBA editor, so that others could not gain access to the VBA editor to view the coding?
Thanks.
Regards
Hi,
You can't hide the VBA Editor, but you can password protect the project which if effect hides you code and prevents modification.
In the VBA Editor, in the project pane, right click on any of the sheets or workbook in your project, select VBAProject Properties.... then on the Protection Tab, check "Lock project for viewing" and add a password.
Save the Excel File.
Hope this helps
.....Ralph
Hi,
This isn't foolproof (because it relies on the user enabling macros) but is interesting nonetheless. (I think the code was originally provided by Ivan - see his site here : http://xcelfiles.homestead.com/Index.html )
See if it helps you out.
Don’t have an account yet? Register yourself now and be a part of our community!