[ACCEPTED]-Hiding a sheet in Excel 2007 (with a password) OR hide VBA code in Excel-office-2007

Accepted answer
Score: 14

Here is what you do in Excel 2003:

  1. In your sheet of interest, go to Format -> Sheet -> Hide and hide your sheet.
  2. Go to Tools -> Protection -> Protect Workbook, make sure Structure is selected, and enter your password of choice.

Here is 8 what you do in Excel 2007:

  1. In your sheet of interest, go to Home ribbon -> Format -> Hide & Unhide -> Hide Sheet and hide your sheet.
  2. Go to Review ribbon -> Protect Workbook, make sure Structure is selected, and enter your password of choice.

Once this is done, the 7 sheet is hidden and cannot be unhidden without 6 the password. Make sense?


If you really need 5 to keep some calculations secret, try this: use 4 Access (or another Excel workbook or some 3 other DB of your choice) to calculate what 2 you need calculated, and export only the 1 "unclassified" results to your Excel workbook.

Score: 2

No.

If the user is sophisticated or determined 7 enough to:

  1. Open the Excel VBA editor
  2. Use the object browser to see the list of all sheets, including VERYHIDDEN ones
  3. Change the property of the sheet to VISIBLE or just HIDDEN

then they are probably sophisticated 6 or determined enough to:

  1. Search the internet for "remove Excel 2007 project password"
  2. Apply the instructions they find.

So what's on this 5 hidden sheet? Proprietary information like 4 price formulas, or client names, or employee 3 salaries? Putting that info in even an hidden 2 tab probably isn't the greatest idea to 1 begin with.

More Related questions