Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
CDS CDS is offline
external usenet poster
 
Posts: 8
Default Protect just one worksheet of an excel doc?

I have a large excel document, and one of the worksheets within the document
is very confidential. Is there a way to password protect just that one
worksheet within the document?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default Protect just one worksheet of an excel doc?

It depends on how confidential it is, all workbook and worksheet protection
in Excel can be cracked before you even have time to say the word. So I
wouldn't put any real sensitive data in any spreadsheet. If not it's under
toolsprotectionprotect sheet


--


Regards,


Peo Sjoblom




"CDS" wrote in message
...
I have a large excel document, and one of the worksheets within the
document
is very confidential. Is there a way to password protect just that one
worksheet within the document?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Protect just one worksheet of an excel doc?

If you want the sheet hidden and not available use ToolsProtectionProtect
Workbook after hiding the sheet.

But note Peo's caveat about Excel internal security.


Gord Dibben MS Excel MVP

On Wed, 26 Sep 2007 09:04:07 -0700, CDS wrote:

I have a large excel document, and one of the worksheets within the document
is very confidential. Is there a way to password protect just that one
worksheet within the document?


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
Protect an Excel WorkSheet from being deleted Trader_in_Paradise Excel Discussion (Misc queries) 6 January 16th 17 07:13 AM
How do I Protect worksheet and use filters also in excel? AJ Excel Discussion (Misc queries) 1 August 8th 06 05:09 PM
How do i protect a worksheet in Excel and still use AutoSum? Jonathan Newman Excel Discussion (Misc queries) 1 July 17th 06 02:12 PM
How can I protect a worksheet yet allow editing in Excel 2000 jimar Excel Discussion (Misc queries) 1 August 26th 05 11:25 AM
How can I protect an excel worksheet containing filters? JMcG Excel Discussion (Misc queries) 4 April 13th 05 03:13 PM


All times are GMT +1. The time now is 02:30 PM.

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"