Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mj mj is offline
external usenet poster
 
Posts: 78
Default Assistance with password in Excel

Hi. Please help. I have an excel sheet with mulitple worksheets. I need to
protect one of them and keep the rest open and available. The worksheet that
I need protected can not be seen at all. Does excel have an option to prompt
me for a password each time the worksheet is accessed? Tools and protection
did not help me because the data can still be seen when I open the document.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 299
Default Assistance with password in Excel

Why don't you hide the sheet and the protect the workbook?

Note that both workbook and sheet protection are ridiculous from a security
standpoint, very easy to crack, all it takes is a Google search, however it
will probably work for the average office user

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)


"MJ" wrote in message
...
Hi. Please help. I have an excel sheet with mulitple worksheets. I need
to
protect one of them and keep the rest open and available. The worksheet
that
I need protected can not be seen at all. Does excel have an option to
prompt
me for a password each time the worksheet is accessed? Tools and
protection
did not help me because the data can still be seen when I open 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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
how do I retrieve/delete a password in Excel? jgarrity Excel Discussion (Misc queries) 2 June 8th 06 06:54 PM
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
How can I open an excel spreadsheet if I forgot the password? SheppyShep Excel Worksheet Functions 1 October 1st 05 01:19 AM
Need to remove a password that noone placed on Excel worksheet. tuffy1104 Excel Worksheet Functions 2 January 2nd 05 07:12 PM


All times are GMT +1. The time now is 06:55 AM.

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

About Us

"It's about Microsoft Excel"