ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Passworded Sheets ? (https://www.excelbanter.com/excel-discussion-misc-queries/87003-passworded-sheets.html)

JacobsBabtie

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


Gary Brown

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


JE McGimpsey

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.



All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com