A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Protect an excel spreadsheet



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2009, 08:31 AM posted to microsoft.public.excel.worksheet.functions
NZuser
external usenet poster
 
Posts: 14
Default Protect an excel spreadsheet

Hello,
Can someone pls tell me what the most secure way to protect a worksheet is?
:-)
  #2  
Old April 14th, 2009, 08:36 AM posted to microsoft.public.excel.worksheet.functions
Dave
external usenet poster
 
Posts: 2,331
Default Protect an excel spreadsheet

Hi NZuser,
If you're using xl2007, the protection is like thick paper.
If you're using anything prior to 2007, the protection is like wet tissues.
When you lock your shed, you're only keeping honest people out. The evil
doer, the devious and the curious will always find their way in.
Regards - Dave.


"NZuser" wrote:

Hello,
Can someone pls tell me what the most secure way to protect a worksheet is?
:-)

  #3  
Old April 14th, 2009, 08:38 AM posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
 
Posts: 8,419
Default Protect an excel spreadsheet

Hi,

Can someone pls tell me what the most secure way to protect a worksheet is?


I'm afraid the answer is don't give it to anyone but for the most part that
isn't practical. There isn't a secure way at all, Excel worksheet protection
is designed to protect against inadverdant or accidental deletions and while
it may deter the inexperienced, anyone with Google and a bit of resolve can
remove your passwords very quickly.

Mike

"NZuser" wrote:

Hello,
Can someone pls tell me what the most secure way to protect a worksheet is?
:-)

  #4  
Old April 14th, 2009, 08:45 AM posted to microsoft.public.excel.worksheet.functions
NZuser
external usenet poster
 
Posts: 14
Default Protect an excel spreadsheet

Thanks Mike H and Dave! This has definitely answered my question :-)

"Mike H" wrote:

Hi,

Can someone pls tell me what the most secure way to protect a worksheet is?


I'm afraid the answer is don't give it to anyone but for the most part that
isn't practical. There isn't a secure way at all, Excel worksheet protection
is designed to protect against inadverdant or accidental deletions and while
it may deter the inexperienced, anyone with Google and a bit of resolve can
remove your passwords very quickly.

Mike

"NZuser" wrote:

Hello,
Can someone pls tell me what the most secure way to protect a worksheet is?
:-)

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:15 PM.


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