CivilEA.com
  • Subscribe !
  • Register
  • Login
  • Home
  • Members
  • Help
  • Search
Connect with your social network account

Civil Engineering Association Civil Engineering Resource Civil Engineering Documents Engineering Spreadsheet Internal EXCEL passwords remover

Internal EXCEL passwords remover
 brass

Member

Registered
White-private
User ID: 6948
Joined: Sep 2009
Posts: 47
Threads: 13
Likes: 426 in 47 posts
Given Likes: 140
Points: 3,987 EP

#1
12-23-2010, 11:22 AM (This post was last modified: 05-02-2011, 06:33 AM by kowheng.)
The following .xls file can be used to remove internal protections in excel (i.e. workbook & worksheet).

Instructions after downloading the file from the given link:

1. Load the file: "allinternalpasswords.xls" in excel
2. If asked, Enable Macros
3. Go to: File > Open...
4. Select and open the excel file you want to remove the protection from
5. Go to: Add-Ins > Remove Passwords or if older version execute/run macro with name "allinternalpasswords.xls!AllInternalPasswords"
6. After macro finishes task (it takes some seconds depending also on PC speed), save the unprotected workbook with a new name.
7. Your coffee is getting cold, have a sip now.

***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************


Direct Link:

.xls   allinternalpasswords.xls (Size: 28.5 KB / Downloads: 456)


WARNING: SOME EXCEL WORKBOOK AUTHORS INCLUDE ALGORITHMS THAT CHECK IF THE WORKBOOK HAS BEEN ALTERED OR UNPROTECTED. IN SOME CASES THE UNPROTECTED WORKBOOKS CAN GIVE FALSE RESULTS AND/OR LOSE FUNCTIONALITY. ALWAYS DOUBLE CHECK!!!


Also, if you modify an excel workbook by unprotecting it and you post it here, also post the original one and make a note about this in your post. Engineering is an exact science; mistakes can cost lives, money ans careers so we should be careful when modifying original code.



[-] The following 34 users Like brass's post:34 users Like brass's post
  • utan, we_mbm, chigozie, gelbert, ska51, nhim4mat2006, Yasir, mrgoodboydatdat, barukai, adams, hmwere, rkce, miquan, sodapas, ravisbassi, jcbv, narendra, levanduy, hassananas, ruaumoko, relu59, chenamoy, vinnunsam, abouferass88, engr1900, hm20284, sasan7351, oreslaw, joinsms, andersen3, smrutigandh.42, bigone, tattiya, spat
 cadtfoi

Member

Registered
White-private
User ID: 4176
Joined: Aug 2009
Posts: 32
Threads: 19
Likes: 345 in 35 posts
Given Likes: 98
Points: 2,783 EP

#2
12-23-2010, 11:25 AM
There is a more simply way, use openoffice excell, it crashes almost all of the microsoft excell passwords.



[-] The following 4 users Like cadtfoi's post:4 users Like cadtfoi's post
  • chigozie, nhim4mat2006, jcbv, bigone
 brass

Member

Registered
White-private
User ID: 6948
Joined: Sep 2009
Posts: 47
Threads: 13
Likes: 426 in 47 posts
Given Likes: 140
Points: 3,987 EP

#3
12-23-2010, 11:39 AM
Dear Cadtfoi,

I doubt your way is more simple. The Openoffice pack is 148 MB to download and it takes also time to download, install as well as unnecessary hard drive space if you just need it for once to remove a worksheet protection. Also it is not 100% compatible with Micr0s0ft Excel, the same for Google docs etc.
The .xls file I posted is just 28 Kb, it needs no installation and it is made for MS Excel.

Cheers



[-] The following 10 users Like brass's post:10 users Like brass's post
  • chigozie, gelbert, ska51, Yasir, mrgoodboydatdat, ssi3k, sodapas, ravisbassi, oanm2000, smrutigandh.42
 ravisbassi

Semi Senior Member

Banned
White-private
User ID: 29476
Joined: Sep 2010
Posts: 82
Threads: 9
Likes: 181 in 71 posts
Given Likes: 743
Points: 5,374 EP

#4
01-08-2011, 09:37 AM
(12-23-2010, 11:22 AM)shpatone Wrote: WARNING: SOME EXCEL WORKBOOK AUTHORS INCLUDE ALGORITHMS THAT CHECK IF THE WORKBOOK HAS BEEN ALTERED OR UNPROTECTED. IN SOME CASES THE UNPROTECTED WORKBOOKS CAN GIVE FALSE RESULTS AND/OR LOSE FUNCTIONALITY.

shpatone - can you please provide some insight and/or details of these algorithms. I am curious and asking for educative purpose.




  •
 brass

Member

Registered
White-private
User ID: 6948
Joined: Sep 2009
Posts: 47
Threads: 13
Likes: 426 in 47 posts
Given Likes: 140
Points: 3,987 EP

#5
01-08-2011, 11:08 AM
The Function code for checking if a worksheet or workbook is protected is (scroll inside window) :

PHP Code:
Function IsProtected(objXL As Object) As Boolean
Dim wksht 
As Excel.Worksheet
Dim cell 
As Excel.Range

Select 
Case TypeName(objXL)
  Case 
"Worksheet"
    
If objXL.ProtectContents Then
      
' still doesn't mean you can't edit the worksheet!
     Select Case Cells.Locked
        Case True ' 
all cells are locked AND worksheet is protected
         
IsProtected = True
          
Exit Function
      
End Select
    End 
If
  Case 
"Workbook"
    
If objXL.ProtectStructure Then
      IsProtected 
= True
      
Exit Function
    
End If
    For 
Each wksht In objXL.Worksheets
      
If wksht.ProtectContents Then
        
' still doesn't mean you can't edit the worksheet!
       Select Case Cells.Locked
          Case True ' 
all cells are locked AND worksheet is protected
           
IsProtected = True
            
Exit Function
        
End Select
      End 
If
    
Next wksht
  
Case "Range"
    
If objXL.Cells.Count = 1 Then
      
If (objXL.Locked And objXL.Parent.ProtectContents) Or (IsProtected(objXL.Parent.Parent)) Then
        IsProtected 
= True
        
Exit Function
      
End If
    Else
      For 
Each cell In objXL
        
If (cell.Locked And cell.Parent.ProtectContents) Or (IsProtected(cell.Parent.Parent)) Then
          IsProtected 
= True
          
Exit Function
        
End If
      
Next cell
    End 
If
End Select
End 
Function 

The usage is (scroll inside window) :

PHP Code:
Dim wkb As Excel.Workbook
Set wkb 
= ActiveWorkbook
If IsProtected(wkb) Then
  Msgbox 
"It's protected!"
End If
' or
Dim wksht As Excel.Worksheet
Set wksht = ActiveSheet
If IsProtected(wksht) Then
  Msgbox "It'
s protected!"
End If
' or
Dim rng as Excel.Range
Set rng = Range("
A3")
If IsProtected(rng) Then
  Msgbox "
It's protected!"
End If 

For more explanations go to:

***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************




[-] The following 5 users Like brass's post:5 users Like brass's post
  • ravisbassi, jcbv, mz55, bigone, sasan7351
 ynopum

Professional Member

Registered
Burundi
User ID: 2733
Joined: Jul 2009
Posts: 326
Threads: 26
Likes: 2,415 in 367 posts
Given Likes: 155
Points: 19,012 EP

#6
01-08-2011, 11:39 AM
I don't think that such 'protection check' can really work, as you can always see and change the program code to bypass it.

If you want to protect your code, just make a XLA file using Office 95 (not 97 or newer).
It seems to me that it's not a professional attitude to use MS-Office for commercial application development, but you can see enough examples for people trying to make money this way.



[-] The following 1 user Likes ynopum's post:1 user Likes ynopum's post
  • ravisbassi
 brass

Member

Registered
White-private
User ID: 6948
Joined: Sep 2009
Posts: 47
Threads: 13
Likes: 426 in 47 posts
Given Likes: 140
Points: 3,987 EP

#7
01-08-2011, 11:48 AM
I agree with you ynopum, the protection can be bypassed, but don't forget that the average user does not know how to do that. Also the code can be encrypted, so then it gets more difficult to "see" anything.



[-] The following 2 users Like brass's post:2 users Like brass's post
  • ravisbassi, engr1900
 Jeffrey Toledo

Not-Activated

White-private
User ID: 30038
Joined: Oct 2010
Posts: 9
Threads: 13
Likes: 73 in 6 posts
Given Likes: 50
Points: 892 EP

#8
01-25-2011, 02:50 AM
hey guys i've tried this excel sheet, it works on simple excel sheet but it does not work on LOCKED.XLS file and STK3lock.xla files. Can anyone have a file or a software to remove a protected sheet on LOCKED.XLS file and a STK3locked.xla file? Please!


regards

Jeff



[-] The following 1 user Likes Jeffrey Toledo's post:1 user Likes Jeffrey Toledo's post
  • engr1900
 HomerMTY

Not-Activated

White-private
User ID: 286
Joined: Jan 2009
Posts: 2
Threads: 0
Likes: 12 in 2 posts
Given Likes: 3
Points: 180 EP

#9
01-25-2011, 03:55 PM (This post was last modified: 01-25-2011, 04:07 PM by kowheng.)
Try Excel Utilities, its a free Excel Add-ins. This have a command Break Password that worked fine for me.

***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************




[-] The following 5 users Like HomerMTY's post:5 users Like HomerMTY's post
  • chenamoy, Umer.Aleem, sasan7351, engr1900, oreslaw
 bigone

Professional Member

Registered
United Nations
User ID: 4505
Joined: Aug 2009
Posts: 515
Threads: 93
Likes: 5,716 in 517 posts
Given Likes: 7140
Points: 24,674 EP

#10
07-20-2011, 06:40 AM
(12-23-2010, 11:25 AM)cadtfoi Wrote: There is a more simply way, use openoffice excell, it crashes almost all of the microsoft excell passwords.

that is right, and i tried and working fine.

openoffice source download:
***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************


here a picture for sample file & steps:

[Image: 17935923285006700506.png]





[-] The following 8 users Like bigone's post:8 users Like bigone's post
  • engr1900, Dell_Brett, oanm2000, duazo2009, hm20284, sasan7351, zonoiko, r3be1
« Next Oldest | Next Newest »

Users browsing this thread: 1 Guest(s)



Possibly Related Threads…
Thread Author Replies Views Last Post
  Retaining Wall with Counterfort Check of Stability and Caculation of Internal forces bigone 1 8,592 04-09-2014, 06:23 AM
Last Post: bigone

  • View a Printable Version
  • Subscribe to this thread

Designed by CivilEA - Powered by MyBB

Linear Mode
Threaded Mode