Deny access to VBA code for unauthorized users

[flummi]

Hi all,

Does anyone know how to deny access to the VBA code of a workbook for
all users except the developer?

The background is this.

We have a workbook that collects data from users and has a lot of VBA
code. All controls and sheets are driven by that code and all sheets
are protected.

But for certain actions the code needs to unprotect the sheet, update
cells and protect it again.

This obviously reveals the passwords required for unprotecting the
sheets.

Your help is very much appreciated.

Thanks.

Hans

 

[prabhuraaman]

Go to the Visual Basic Editor
Go to TOOLS menu
Clik VBA PROJECT PROPERTIES
Cilk the PROTECTION tab
Check the LOCK PROJECT FOR VIEWING box
Enter your password

If you like this solution, you may also like
http://groups.google.co.in/group/Answers-for-everything/browse_thread/thread/946502c223298627
http://groups.google.co.in/group/Answers-for-everything/browse_thread/thread/1b7a6ecc82c9cb75

For more,post your questions on
http://groups.google.co.in/group/answers-for-everything
or e-mail to
(e-mail address removed)

 

[flummi]

You are a genious!

Thanks a LOT!

Best regards

Hans