| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Passworded Sheets ?
Is it possible to make a sheet passworded so that you can only *unhide* it when you have typed in a password. I have a spreadsheet that needs to be sent to potential clients but it relies on data on other sheets for some information to be calculated. I dont want my clients seeing this so i was wondering if it was possible to make it so they cannot unhide some of the sheets within the workbook. Thanks in advance, ! -- JacobsBabtie ------------------------------------------------------------------------ JacobsBabtie's Profile: http://www.excelforum.com/member.php...o&userid=34108 View this thread: http://www.excelforum.com/showthread...hreadid=539187 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Passworded Sheets ?
Hide the sheet and then Protect the Workbook as opposed to protect the sheet -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=539187 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Passworded Sheets ?
No. Anything you include in an XL workbook should be considered public
info. XL's protection mechanisms are incredibly easy to bypass. In article , JacobsBabtie wrote: Is it possible to make a sheet passworded so that you can only *unhide* it when you have typed in a password. I have a spreadsheet that needs to be sent to potential clients but it relies on data on other sheets for some information to be calculated. I dont want my clients seeing this so i was wondering if it was possible to make it so they cannot unhide some of the sheets within the workbook. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert Rows with Formulas in Place on Multiple Sheets? | Excel Discussion (Misc queries) | |||
| Macros-creating new sheets | Excel Worksheet Functions | |||
| Autofilter Lists across Multiple Sheets, Maintain Correct Referenc | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Hybrid Mode
