I had to use this today to help a client modify a worksheet that was protected by an ex-employee. Please use this information responsbily.

PS) it works in office 2007

Hope it helps someone else..

Microsoft Excel

Crack Sheet Protection Password

This routine provides a password to unprotect your worksheet. However, it may not give you the original password that was used.

Open the workbook that has the protected sheet in it. Hit Alt+F11 to view the Visual Basic Editor. Hit Insert-Module and paste this code into the right-hand code window:

Sub PasswordBreaker()
‘Author unknown but submitted by brettdj of www.experts-exchange.com

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)
ActiveWorkbook.Sheets(1).Select
Range(”a1″).FormulaR1C1 = 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

Close the VB Editor window. Navigate to the worksheet you want to unprotect. Hit Tools-Macro-Macros and double-click PasswordBreaker in the list.

Copyright (C) 1997-2010, Chris Coulson and Coulson Technologies, LLC. All Rights Reserved Worldwide.

Attorney’s advice after becoming a victim of identity theft.

ATTORNEY’s ADVICE - NO CHARGE

Read this and make a copy for your files in case you need to refer to it someday. Maybe we should all take some of his advice! A corporate attorney sent the following out to the employees in his company.

Unfortunately, I, an attorney, have first hand knowledge because my wallet was stolen last month. Within a week, the thieve(S) ordered an expensive monthly cell phone package, applied for a VISA credit card, had a credit line approved to buy a Gateway computer, received a PIN number from DMV to change my driving record information online, and more.

But here’s some critical information to limit the damage in case

this happens to you or someone you know:

1) Do not sign the back of your credit cards. Instead, put ‘PHOTO ID REQUIRED.’

2) When you are writing checks to pay on your credit card accounts, DO NOT put the complete account number o n the ‘For’ line. Instead, just put the last four numbers. The credit card company knows the rest of the number, and anyone who might be handling your check as it passes through all the check processing channels won’t have access to it.

3) Put your work phone # on your checks instead of your home phone. If you have a PO Box use that instead of your home address. If you do not have a PO Box, use your work address. Never have your SS# printed on your checks. (DUH!) You can add it if it is necessary. But if you have It printed, anyone can get it.

4) Place the contents of your wallet on a photocopy machine. Do both sides of each license, credit card, etc. You will know what you had in your wallet and all of the account numbers and phone numbers to call and cancel. Keep the photocopy in a safe place.

I also carry a photocopy of my passport when I travel either here or abroad. We’ve all heard horror stories about fraud that’s committed on us in stealing a Name, address, Social Security number, credit cards.

5) We have been told we should cancel our credit cards immediately. But the key is having the toll free numbers and your card numbers handy so you know whom to call. Keep those where you can find them.

6) File a police report immediately in the jurisdiction where your credit cards, etc., were stolen. This proves to credit providers you were diligent, and this is a first step toward an investigation (if there ever is one).

But here’s what is perhaps most important of all: (I never even thought to do this.)

7) Call the 3 national credit reporting organizations immediately to place a fraud alert on your name and also call the Social Security fraud line number. I had never heard of doing that until advised by a bank that called to tell me an application for credit was made over the internet in my name.

The alert means any company that checks your credit knows your information was stolen, and they have to contact you by phone to authorize new credit.

By the time I was advised to do this, almost two weeks after the theft, all the damage had been done. There are records of all the credit checks initiated by the thieves’ purchases, none of which I knew about before placing the alert. Since then, no additional damage has been done, and the thieves threw my wallet away this weekend (someone turned it in). It seems to have stopped them dead in their tracks.

Now, here are the numbers you always need to contact about your

wallet, if it has been stolen:

· Equifax: 1-800-525-6285

· Experian (formerly TRW): 1-888-397-3742

· Trans Union : 1-800-680 7289

· Social Security Administration (fraud line): 1-800-269-0271

We pass along jokes on the Internet; we pass along just about everything. If you are willing to pass this information along, it could really help someone that you care about.

Copyright (C) 1997-2010, Chris Coulson and Coulson Technologies, LLC. All Rights Reserved Worldwide.

Our office has recently decided to go with sharepoint for an intranet.  One of the main questions was.. can I embed video into sharepoint blogs?

After finding out

There is the way of using the “Contenet Web Editor” webpart.  The thing is if the video changes, you have no history like you do with a normal blog.

The only true way to get this to work, is to embed in a blog.

I found 2 sites

1) http://www.youtube.com/watch?v=2-5nfadPNoI (This link was great walk through but did not work for me)

2) This was the foundation of the code I created.

Add Youtube Video into Sharepoint with Full Screen

Scribed

http://www.scribd.com/doc/4289944/Adding-Youtube-Videos-into-Blog

Copyright (C) 1997-2010, Chris Coulson and Coulson Technologies, LLC. All Rights Reserved Worldwide.

Back in thanksgiving I had to reformat and reinstall my computer.

Today I just finished adding several extensions to both firefox and thunderbird.

The most noteable plugin is the lightning (calendar) plug in, that also works with google calendars.

Here is the steps, and it worked like a charm for me.

http://bfish.xaedalus.net/?p=239

Copyright (C) 1997-2010, Chris Coulson and Coulson Technologies, LLC. All Rights Reserved Worldwide.

It’s the holiday season and many of us do online shopping. Many online shoppers do not know the risks involved with online shopping.

Remember: an ounce of prevention is worth a pound of cure.

Here is a recent speech I gave at a local Toastmasters Meeting.

Enjoy….

[podcast]

Copyright (C) 1997-2010, Chris Coulson and Coulson Technologies, LLC. All Rights Reserved Worldwide.

 

 Online Shopping [5:44m]: Play Now | Play in Popup | Download

Windows system key combinations

Windows program key combinations

Mouse click/keyboard modifier combinations for shell objects

General keyboard-only commands

Shell objects and general folder/Windows Explorer shortcuts

For a selected object:

To copy a file

Press and hold down the CTRL key while you drag the file to another folder.

To create a shortcut

Press and hold down CTRL+SHIFT while you drag a file to the desktop or a folder.

General folder/shortcut control

Windows Explorer tree control

Properties control

Accessibility shortcuts

Microsoft Natural Keyboard keys

Microsoft Natural Keyboard with IntelliType software installed

Dialog box keyboard commands

Copyright (C) 1997-2010, Chris Coulson and Coulson Technologies, LLC. All Rights Reserved Worldwide.