I have saved a copy of an Excel formatted timesheet to use twice a month.
Unfortunately the staff who created the document in Excel did not leave the
password he assigned the excel document. I need access to resize the columns
so it will not show ### symbols because the column is too short. I have
copied the original version so it will stay intact. I need to be able to
edit the column sizes. Thank you for your assistance.

WK Ph.: (907) 465-5915, toll free: 1-888-448-3525 ext. 5915
Thank you. Alan Duncan Munro

I'm assuming its WorkSheet, not WorkBook protection, This macro will
unprotect the WorkSheet,

Sub PasswordBreaker()

'by Bob McCormick on NG: microsoft.public.excel.misc

'on 22 May 2001.

'Breaks worksheet password protection.

Dim i As Integer, j As Integer, k As Integer

Dim l As Integer, m As Integer, n As Integer

Dim i1 As Integer, i2 As Integer, i3 As Integer

Dim i4 As Integer, i5 As Integer, i6 As Integer

On Error Resume Next

For i = 65 To 66: For j = 65 To 66: For k = 65 To 66

For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66

For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66

For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126

ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _

Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) _

& Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

If ActiveSheet.ProtectContents = False Then

MsgBox "One usable password is " & Chr(i) & Chr(j) _

& Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) _

& Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

Exit Sub

End If

Next: Next: Next: Next: Next: Next

Next: Next: Next: Next: Next: Next

End Sub



Go Alt and F11 to open the VB editor

On the Toolbar go 'Insert' 'Module'

In the new window, copy and paste the code above

Go Alt and F11 again to close the VB editor

In the normal XL window go 'Tools' 'Macros' 'Macros' Select
'PasswordBreaker' and click 'Run'

Save the file once its unprotected.



Do this on a copy to avoid any possible corruption of the original.



Regards,

Alan.

"Duncan" wrote in message
...
I have saved a copy of an Excel formatted timesheet to use twice a month.
Unfortunately the staff who created the document in Excel did not leave
the
password he assigned the excel document. I need access to resize the
columns
so it will not show ### symbols because the column is too short. I have
copied the original version so it will stay intact. I need to be able to
edit the column sizes. Thank you for your assistance.

WK Ph.: (907) 465-5915, toll free: 1-888-448-3525 ext. 5915
Thank you. Alan Duncan Munro

See

http://www.mcgimpsey.com/excel/removepwords.html

In article ,
Duncan wrote:

I have saved a copy of an Excel formatted timesheet to use twice a month.
Unfortunately the staff who created the document in Excel did not leave the
password he assigned the excel document. I need access to resize the columns
so it will not show ### symbols because the column is too short. I have
copied the original version so it will stay intact. I need to be able to
edit the column sizes. Thank you for your assistance.