'View Code' Macros

[Always_A_Newbie]

Hi there,
I have a protected sheet set that way inside a macro, but allows the macro access, and have set the password inside the macro.
I needed to do it like this because I wanted the sheet to be protected from user input but also needed the macros to be able to alter these protected fields. Someone showed me how to do this from here, cheers.
But problem is, this sheet protection isn't really any good as if anyone wanted to do anything to the sheet they shouldn't, they just right click the green icon->view code->see the password, change the password etc.

Is there any way to password protect the 'View Code' option?

 

[dk]

Certainly is:-

In the Visual Basic Editor click Tools, VBAProject Properties, click on the Protection tab. Just tick the Lock Project for viewing checkbox and type a password.

Next time you open your workbook your code will be protected.

 

[Always_A_Newbie]

Cheers mate, such a friendly and fast forum.

Could ya help me out again, this Workbook will be run on a Network, does ticking this box effect the Excel program itself, or is it stored in the file?

In other words, can I do this once inside the sheet and save it, or do I need to go around every machine and tick this box?

Thanks again.

 

[dk]

Well we aim to please

The password protection will apply to the file. If you send it to someone else or place it on a network drive it will still be protected until someone either unlocks it with the password or hacks it.