Hidding vba code and lock cells??

Hii All,

Please ,I Really Need a Urgent Solution for this problem...

1) Is it possible to hide all the Vba project code's in worksheet from all other user??? i tried to put a password for vba project veiwing so far the password is working for my workbook ,BUT Even the Vba project viweing is locked with password ,when I try to move or copy any sheet from my workbbok to another workbook, my codes also moving without any password protection and is viewable in other workbook which is a BIG Problem, Is there any way out to secure everything in my workbook??? or freezing move /copy and add new sheet option so that no one can see the workbook codes?

2) Is there VBA solution to lock and hide for selected cells in worksheet so that no one can see the formula and no one can change anything on the selected cells without protecting sheet..

Thank you.

Of course no method is going to fully protect your file. It basically keeps the casual and mostly honest user from making critical changes.

No, you can not protect the sheet contents if you don't lock the cells and protect the sheet. If you are storing sensitive information, protect the sheet and only allow a secure user to change it. e.g. If Environ("username")='"yours" then a macro would unhide the sheet and then rehide it when you change sheets.

I normally set each sheet's Protect with UserInterfaceOnly:=True in ThisWorkbook's Open event so code can make changes without sheet Unprotect/Protect.

Some have hidden all sheets but one at workbook Close and set sheet visible to normal at Open based on username.

Cell Number Format can be set to ;;; to "hide" the value but the formula bar will show the value.