Unhide VeryHidden Excel Worksheets
Here is the macro I use to unhide very hidden worksheets.
Sub Unhide()
Dim ws As Worksheet
For Each ws In Sheets
ws.Visible = True
Next
End Sub
FIX: “The Application HTC Sense (process com.htc.launcher) has stopped unexpectedly”
Today I did a factory reset on my T-Mobile My Touch 4G however on reboot I continued to get the following error:
Sorry!
The Application HTC Sense (process com.htc.launcher) has stopped unexpectedly.
Please Try Again.
The only option available was Force Close, and soon as that was pressed the message would appear again.
I tried the solutions listed at http://myhtcdesire.com/tutorials/fix-the-application-htc-sense-process-com-htc-launcher-has-stopped-unexpectedly, if the directions on that site work all the better, however if you are in the same boat as me those directions did not work.
My Problem:
On my phone I did have any way of getting to the search, nothing on screen, and no buttons would work. Just hitting force close brought the force close option up instantly again and I had no time to do anything. So how did I get into the settings menu?
How I got into the settings menu:
The only way I was able to get was to do a factory reset though the boot menu.
You can perform a factory reset by (second half of this video) restarting the phone while holding the volume button down. This will cause you to boot into your factory menu where you can select factory reset.
Once the factory reset gave me more time to react before the error popped up. Once the reset was done I was prompted with an introductory video all about my phone. I went through all the prompts until my home screen was loading. Right away before anything loaded I pushed and held on the home screen. This caused the option to add a shortcut to the home screen. I was able to add a shortcut to settings and get to it that way.
After that I was able to clear the data to go to Applications > Manage Applications > HTC Sense > and Clear Data. However this did not fix it for me. Instead I had to clear data on all my
applications until I found the one that was causing the problem.
Did this post save your expensive phone from being a paper weight? Did it save you hours of fustration? Consider buying me a coffee!
Distributing XULRunner with ClickOnce
Recently I was working on ClickOnce Application and I was trying to distribute XULRunner with my application. Unfortunately when deploying the application I realized that not all the files where included in the ClickOnce applications file, particularly text files such as files that ended in .ini or .manifest.
The solution was to go into the solution explorer in Visual Studio, select the files that there not being copied, and set the build action to content for those files.
Cannot import the following key file fix
This one has caused me a few hours of pain….a couple of time. It is about time I document how I fixed it.
The Error:
Cannot import the following key file: <filename>.pfx. The key file may be password protected. To correct this, try to import the certificate again or manually install the certificate to the Strong Name CSP with the following key container name: VS_KEY_ E2AEBF22AB52DD08 <Application Name>
The Fix:
- Open Visual Studio Command Prompt (It can be found in the Windows Start menu)
- Type sn -i “c:\Pathtofile\<filename>.pfx” TVS_KEY_ E2AEBF22AB52DD08
- Reimport the pfx file into Visual Studio
The sn.exe with the –i parameter, installs a key pair from <infile> into a key container named <container>.
Display driver stopped responding – Flash Green Screen
The Problem:
Recently I was working on a customers computer and when loading a page with a flash video on it, the video would crash.The following message was displayed in the system tray.
Display driver stopped responding and has recovered.

The machine I was working on was a Dell Inspiron n5010 with a ATI mobility Radeon HD 5470 video card running Windows 7 x64bit. After all the normal troubleshooting and making sure I had the most up -to-date drivers I still had the issue. I ended up coming up with the following solution.
The solution:
Disable Hardware acceleration by right clicking on any flash video, going to settings and unchecking enable hardware acceleration.

I hope this saves someone a head ache.