protecting excel macros from being changed/ seen by user

J

jon tebbens

How do I protect / hide a macro, so that is functions on
the worksheet, but is not available to the user?
Thanks,
Jon
 
S

steve

Jon,

Go to the VBE

From the Tools menu protect the project with a password and save.

The next time the workbook is opened it will require a password to view
the code.

But remember a serious "hacker" can get in...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Protecting Word 2019 document 0
Password for running Macro 2
Template location changes from user to user 0
Issue With Macro Sheduling Using On Time Event 0
Override protected sheet message? 4
Copy data using macro (with worksheet protect) 5
Copying in sheet with protection with the use of a macro 5

Top