Prohibit seeing/modifying VB code

  • Thread starter Thread starter Kevin
  • Start date Start date
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
 
Kevin,

For the novice snooper, use Tools, VBAProject Properties - Protection - Lock
Project for viewing. For the serious user, don't use Excel.
 
You must log in or register to reply here.

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

To protect user's privacy 1
Option Private Module (for Object Modules) 5
Last Modified By in a cell by user 3
Can UDF modify worksheet(s)? 5
Triggering procedures 3
Preventing User Access to VB code 2
Excel Protection 2
Excel VB documentation and coding asistance 5

Back
Top