[ACCEPTED]-Hiding a sheet in Excel 2007 (with a password) OR hide VBA code in Excel-office-2007
Here is what you do in Excel 2003:
- In your sheet of interest, go to Format -> Sheet -> Hide and hide your sheet.
- 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:
- In your sheet of interest, go to Home ribbon -> Format -> Hide & Unhide -> Hide Sheet and hide your sheet.
- 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.
If the user is sophisticated or determined 7 enough to:
- Open the Excel VBA editor
- Use the object browser to see the list of all sheets, including VERYHIDDEN ones
- Change the property of the sheet to VISIBLE or just HIDDEN
then they are probably sophisticated 6 or determined enough to:
- Search the internet for "remove Excel 2007 project password"
- 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