#1   Report Post  
Old May 13th 07, 05:36 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27
Default Worksheet password


Hi !
I know that you can prevent other users from opeing your excel book by
locking it with a password. But my incomes workbook has 8 sheets out of which
one sheet is confidential. I do not want somebody to to be able to prview
that sheet without a password. I do not mind if other worksheets are open to
public view in the same workbook. I have not been able to find a solution to
that. Could you help me out ?
Thanks

Dr Alok Modi MD

  #3   Report Post  
Old May 13th 07, 06:55 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 661
Default Worksheet password

You could open the confidential worksheet, select the colums that have
information in them, hide the columns then use sheet protection to keep the
information hidden using a password. To view and edit the sheet you would
have to unprotect the sheet, unhide the columns to edit then rehide and
protect the sheet. You could also hide the sheet after protecting it by
right clicking on the sheet name and selecting hide. That way it would not be
immediately know that it existed. Rt clicking on another sheet will give the
unhide option.

"Dr Alok Modi MD" wrote:


Hi !
I know that you can prevent other users from opeing your excel book by
locking it with a password. But my incomes workbook has 8 sheets out of which
one sheet is confidential. I do not want somebody to to be able to prview
that sheet without a password. I do not mind if other worksheets are open to
public view in the same workbook. I have not been able to find a solution to
that. Could you help me out ?
Thanks

Dr Alok Modi MD

  #4   Report Post  
Old May 13th 07, 07:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Worksheet password

FormatSheetHide.

ToolsProtectionProtect Workbook with a password.

Note: Excel's internal security is very weak and passwords easily cracked.

My advice is..............if you don't want someone to see data in a workbook,
don't include the data in that workbook.


Gord Dibben MS Excel MVP

On Sun, 13 May 2007 09:36:01 -0700, Dr Alok Modi MD
wrote:


Hi !
I know that you can prevent other users from opeing your excel book by
locking it with a password. But my incomes workbook has 8 sheets out of which
one sheet is confidential. I do not want somebody to to be able to prview
that sheet without a password. I do not mind if other worksheets are open to
public view in the same workbook. I have not been able to find a solution to
that. Could you help me out ?
Thanks

Dr Alok Modi MD


  #5   Report Post  
Old May 14th 07, 02:19 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27
Default Worksheet password



"Gord Dibben" wrote:

FormatSheetHide.

ToolsProtectionProtect Workbook with a password.

Note: Excel's internal security is very weak and passwords easily cracked.

My advice is..............if you don't want someone to see data in a workbook,
don't include the data in that workbook.


Gord Dibben MS Excel MVP

On Sun, 13 May 2007 09:36:01 -0700, Dr Alok Modi MD
wrote:


Hi !
I know that you can prevent other users from opeing your excel book by
locking it with a password. But my incomes workbook has 8 sheets out of which
one sheet is confidential. I do not want somebody to to be able to prview
that sheet without a password. I do not mind if other worksheets are open to
public view in the same workbook. I have not been able to find a solution to
that. Could you help me out ?
Thanks

Dr Alok Modi MD


Thanks

I already have password protected my workbook. But hiding and unhiding the
sheet is not a foolproof method. I needed to know if there is another method
of entering another password for the sheet only besides the book password
protection?

Dr Alok Modi MD




  #6   Report Post  
Old May 14th 07, 03:53 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3,365
Default Worksheet password

One method that would be a little more secure, but at the price of being less
convenient for you to view/work with this sheet would be to:
Open up the VB Editor ([Alt]+[F11])
If the Project - VBA Project window is not visible (says that at the top of
it and has list of worksheets in the workbook in it), choose View [Project
Browser] from the VB Editor menu (or [Ctrl]+R)

Click on the worksheet name you wish to seriously hide. Look at it's
properties in the Properties window. As with the Project window, if it isn't
visible, choose View | Properties Window (or [F4])
at the bottom of the list will be the Visible setting. Use the dropdown
list to set it to xlVeryHidden.

This makes the sheet invisible and keeps it from showing up in the list of
sheets available to be made visible while in Excel.

This alone may be enough (combined with workbook password) to keep prying
eyes away from it. But if you want even more protection:

Decide on a VB Project password. Write it down somewhere - if you lose
this, it will be very difficult to get back into your VB project to make the
sheet visible later. While still in the VB Editor and with your sheet set to
xlVeryHidden, go to the menu bar's Tools option and choose VBAProject
Properties. Click on the [Protection] tab, check the "Lock Project from
Viewing" option and enter and confirm your password.

Close the workbook and reopen it and you should not see your sheet, and you
should not be able to get into the VB Editor without providing the password.
To work with the sheet, provide your password to get back into the VB Editor
and set the sheet's visible property back to xlVisible.

I think that's going to be about as good as it gets, maybe. But as Gord has
noted, bypassing all of this kind of thing in Excel is rather simple. I
could take this type of protection, open another workbook while your's is
open and write code to make all sheets in your workbook visible to me. A few
minutes with any of several Excel password cracking programs and it's all
available to me.

Gord's final advice of "if you don't want someone to see it, don't make it
part of the workbook" is the only sure way of keeping it confidential.




"Dr Alok Modi MD" wrote:



"Gord Dibben" wrote:

FormatSheetHide.

ToolsProtectionProtect Workbook with a password.

Note: Excel's internal security is very weak and passwords easily cracked.

My advice is..............if you don't want someone to see data in a workbook,
don't include the data in that workbook.


Gord Dibben MS Excel MVP

On Sun, 13 May 2007 09:36:01 -0700, Dr Alok Modi MD
wrote:


Hi !
I know that you can prevent other users from opeing your excel book by
locking it with a password. But my incomes workbook has 8 sheets out of which
one sheet is confidential. I do not want somebody to to be able to prview
that sheet without a password. I do not mind if other worksheets are open to
public view in the same workbook. I have not been able to find a solution to
that. Could you help me out ?
Thanks

Dr Alok Modi MD


Thanks

I already have password protected my workbook. But hiding and unhiding the
sheet is not a foolproof method. I needed to know if there is another method
of entering another password for the sheet only besides the book password
protection?

Dr Alok Modi MD


  #7   Report Post  
Old May 15th 07, 03:28 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27
Default Worksheet password

thanks
It is a solution but not that is very smooth and is time consuming. I wish
excel developers would build this in the next version. Thanks for your time
though. I am stuck in the above post also, could you help me there plaese,
nobody seems to have an answer there for me. The post is
titled "data gets rounded up". Thanks

Dr Alok Modi MD


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
Password Protect a Worksheet joinme4coffee Excel Discussion (Misc queries) 8 October 28th 07 08:02 PM
access password to worksheet mrt Excel Worksheet Functions 3 September 1st 06 10:19 PM
password protect worksheet Ben Excel Discussion (Misc queries) 3 February 14th 06 03:30 PM
Password protecting a worksheet [email protected] Excel Worksheet Functions 2 October 5th 05 09:09 PM
Can you password an Excel worksheet, if so how? Coga Excel Worksheet Functions 1 March 24th 05 11:14 PM


All times are GMT +1. The time now is 11:02 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017