Security

Dear Experts,

I'm a newbie in Excel.
Does anyone know how to hide program of macro so that no one can change or read it?
I would like to hide the equations for certain cells as they are confidential to clients. Please help!

Thanks in advance!

Click to expand...

As you may be finding out, this is a issue that calls for compromise. Excel was never meant to be a secure environment, so you are going to have to make some choices. First off, hiding cells, is not the same as hiding macros. I have an application in which all the stuff I don't want users to see are other sheets. Only my inputs are in the first sheet. Check out pennysavers great way he helped me with this construct.

I'm not actually sure that you can hide a macro though. Maybe some of the other (better and smarter) people on this site can help futher.

Gene, "The Mortgage Man", Klein

To protect your code form being viewed:

Open VBE: Alt-F11

If the "Project - VBA Project Explorer" is not visable near the upper left as it's own window, hit: Ctrl-R

In the Project Explorer, Right-Click Select: VBAProject(YourWorkBookNameHere), then from the Right-Click Menu, Select: VBA Project Properties...

Select the "Protection" Tab in the VBA Project Properties Pop-Up: Check: Lock Project for Viewing, Then add a password you won't forget.

OK, then hit the top-most upper right close "X" to return to your Worksheet.

Save the Workbook, then Exit and re-open the same Workbook, from now on or untill you remove the protection [same as add] no one can view your code [without knowing the password or a few tricks (Excel has poor security!) most people will not be able to view your code!].

And to hide your formulas (Not to show in the formula bar), selct those cells, and through Format>Cells>Protection-check both boxes--Locked and Hidden. Now password protect your sheet.
As said above, security in EXCEL cannot be fully relied upon.

It works. Thanks!