#1   Report Post  
Posted to microsoft.public.excel.misc
JacobsBabtie
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Gary Brown
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert Rows with Formulas in Place on Multiple Sheets? Michael Link Excel Discussion (Misc queries) 5 March 9th 06 01:54 PM
Macros-creating new sheets Bonbon Excel Worksheet Functions 3 February 17th 06 09:44 AM
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc EDSTAFF Excel Worksheet Functions 0 November 14th 05 03:27 PM
In 3 active sheets in wkbk, determine& display the # of sheets that have data wrpalmer Excel Discussion (Misc queries) 1 November 4th 05 02:01 PM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM


All times are GMT +1. The time now is 07:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"