Prohibit seeing/modifying VB code

K

Kevin

What is the best way to prevent a user (even a pretty
sophisticated one) from being able to change or even see
the VB modules behind a workbook in Excel?

thanks

Kevin
 
E

Earl Kiosterud

Kevin,

For the novice snooper, use Tools, VBAProject Properties - Protection - Lock
Project for viewing. For the serious user, don't use Excel.
 

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 modifying code 0
Protecting Word 2019 document 0
How to modify and updte specific styles for specific paragraphs across the document 0
New computer, how do i move outlook 365 ENTIRELY? 0
Code to cut a paragraph that's followed by a table 2
Excel 2007, Unable to save new VB code 1
Windows 7 Corrupting Excel 2007 Files with VB Code? 0
Option Private Module (for Object Modules) 5

Top