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  

OT I would want protect my sheets of excel from a "password recovery" software... How?



 
 
Thread Tools Display Modes
  #1  
Old May 30th, 2006, 03:32 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default OT I would want protect my sheets of excel from a "password recovery" software... How?

I would want protect my sheets of excel from a "password recovery"
software... How?

I would want protect my sheets of excel,
I do not want that mine concurrent can open the parts I have protect, with a
"password recovery".
How I can protect my job effectively?

Excuse my English bad one

--
^__^


  #2  
Old May 30th, 2006, 10:09 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default OT I would want protect my sheets of excel from a "password recovery" software... How?

In the final analysis, you can't. But you could code your worksheet so that
macros test whether the sheet and vba project are protected and only supply
critical details/functions if the protection is on.

Cheers


"-= Luca =-" wrote in message
...
I would want protect my sheets of excel from a "password recovery"
software... How?

I would want protect my sheets of excel,
I do not want that mine concurrent can open the parts I have protect, with

a
"password recovery".
How I can protect my job effectively?

Excuse my English bad one

--
^__^




  #3  
Old May 31st, 2006, 09:46 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default OT I would want protect my sheets of excel from a "password recovery" software... How?

Hi macropod,

Let me know if I have understend what you tell me:

I cant protect using excel psw cause psw recovery easyly crack my psw.

but I could do a macro like this:
"if psw=off;select all sheets+cancel all sheets+save all" ? I think this
could be a good protection
but.... i dont know how to do this...couse I dont know VB6 :-( could help me
with a little example?

Your download link: http://www.easy-sharing.com/471922/secret
formula.xls.html

Thank's
Luca

"macropod" ha scritto nel messaggio
...
In the final analysis, you can't. But you could code your worksheet so

that
macros test whether the sheet and vba project are protected and only

supply
critical details/functions if the protection is on.

Cheers



  #4  
Old May 31st, 2006, 10:11 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default OT I would want protect my sheets of excel from a "password recovery" software... How?

Hi Luca,

Not quite, more like:
If ThisWorkbook.Protection = False Then
'Do stuff (eg delete sheet(s), vba modules, then save and exit)
Else
'Do stuff (eg make sheets visible, add formulae/values, then set 'saved'
property to true)
End If

Actually implementing it would largely be workbook/sheet specific, and you'd
need code to deal with file saving & closing, so that your critical
details/functions aren't made available if the user saves, closes & re-opens
the workbook with macros disabled. None of this is bullet-proof, but the
fact that it acts opposite to what most users would expect adds protection.

Cheers


"-= Luca =-" wrote in message
...
Hi macropod,

Let me know if I have understend what you tell me:

I cant protect using excel psw cause psw recovery easyly crack my psw.

but I could do a macro like this:
"if psw=off;select all sheets+cancel all sheets+save all" ? I think this
could be a good protection
but.... i dont know how to do this...couse I dont know VB6 :-( could help

me
with a little example?

Your download link: http://www.easy-sharing.com/471922/secret
formula.xls.html

Thank's
Luca

"macropod" ha scritto nel messaggio
...
In the final analysis, you can't. But you could code your worksheet so

that
macros test whether the sheet and vba project are protected and only

supply
critical details/functions if the protection is on.

Cheers





 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users 5 October 27th, 2005 03:06 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno General Discussion 2 June 13th, 2005 02:01 PM
I can I set up Excel to print all sheets of a workbook as a defau. Trevor Shuttleworth General Discussion 0 January 14th, 2005 11:26 PM
Excel - protect sheet vs. protect workbook DirtbykeDiva General Discussion 3 September 1st, 2004 02:10 AM
Summing excel spread sheets Jim Knaggs Worksheet Functions 2 June 24th, 2004 01:05 AM


All times are GMT +1. The time now is 09:56 AM.


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