Install BlogThis! Button

Two Methods:

1- You can either get the link and drive it your toolbar from here: What is BlogThis! ? - Blogger Help

2-Or you can add as an Extension in Chrome.  I like this method as the icon sits beside your address bar and doesn't take up space (or move around) like it can on your bookmarks bar.  Get the extension for Chrome here: https://chrome.google.com/extensions/detail/pengoopmcjnbflcjbmoeodbmoflcgjlk

To login to VISTA as the Administrator

Here is how to login to Windows VISTA as the Administrator

1. Type CMD in the Start Search box.
2. Open a command prompt in administrator mode by right-clicking and choosing “Run as administrator”
3. In the CMD box, type:  net user administrator /active:yes
4. Log out.
5. You'll now see an option to log in as Administrator
6. When you're ready to disable the visible Administrator option on the login screen, type this into the CMD box:  net user administrator /active:no

(Thanks to: http://www.howtogeek.com/howto/windows-vista/enable-the-hidden-administrator-account-on-windows-vista/ for the help in logging in as Administrator.)

Tivo Not Changing Channels with Motorola DCT700

This worked! Although the box is Motorola, you need to select General Instruments.

Thanks to Broofa on Tivo and Digital Cable Motorola DCT700 [Text View] - TiVo Community:

"To make a long story short, the Motorola DCT700 is, in fact, manufactured by General Instruments (I got this straight from TiVo tech support). So when walking through the channel changing setup you need to choose "GI" as the manufacturer. Crazy huh??? Especially when there isn't a single indication on the box to that effect. :mad: Anyhow, when all is said and done, I landed on the 00093-C IR code for this, which seems to be working just fine.

Now if that's not enough, the tech support weenie gave me the following codes to try: 10006, 10019, 10032, 10042, and 10046. I played around with those as well and the 10046-B setting seemed to work. Some others probably do as well, but I spent too much time on this as it is."

Blogger Search Box Doesn't Work

This works:

You can add another search box (and delete Blogger's version)

In Design mode:
1. Click "add a gadget".
2. Scroll down to html/javascript and select "add to blog"
3. Paste this code:

<form action="/search" method="get">
<input name="q" type="text"/>
<input value="Search" type="submit"/>
</form>

4. Save.

Thanks to davidchin38!

NOTE: If your Blogger blog is not public that is another reason why the Google powered search box does not work.

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Excel | How to conditionally format a cell based on the contents of another cell

The Occasional Tech: How to conditionally format a cell based on the contents of another cell

Block Spam Text Message (Verizon Wireless)

• Sign in to your Verizon Wireless account.
• Select "Safeguards": 

• Select "Call & Message Blocking".
• Type in the spammer's number.

Note: some spammers have a shortened phone number such as 92499999.  Just add two 0's to the beginning of the number to make it 10 digits.  Thus you'd enter 0092499999.

MORE>>
https://text.vzw.com/customer_site/secure/jsp/msg_intercept_new_blocking.jsp: Call & Message Blocking

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.

Stop Auto-correcting Words in Excel

Click the Microsoft Office Button

 and then click Excel Options.

In the Excel Options dialog box, click Proofing, and then click AutoCorrect Options.

How to import/share Flickr photos into Facebook (official Flickr instructions)

How can I use Flickr with Facebook?


Images you upload to Flickr can automatically post to your Facebook updates, letting you share them in both places at the same time. To set up the Facebook connection, just go to Your Account.  Then click "connect".  Since Facebook is owned by Yahoo, what you are doing is connecting your Yahoo account and Facebook.


Please note: Only safe/public images will show on Facebook.

Office Communicator - How to Reopen if if you Closed it Accidentally

You can find it here under All Programs: Microsoft Office Communications Server 2007 R2 Group Chat

EXCEL - Unhide Multiple Worksheets at Once

Note, you can only do this with a VBA macro (there is no shortcut) but it's easy!

Here's how to Create a macro using Microsoft Visual Basic

1. On the Tools menu in Microsoft Excel, point to Macro, and then click Visual Basic Editor.
2. On the Insert menu, click Module.
3. Type or copy the code below into the code window of the module.
4. If you want to run the macro from the module window, press F5.
5. When you're finished writing your macro, click Close and Return to Microsoft Excel on the File menu.

The code:

Sub UnhideAllSheets()
    Dim wsSheet As Worksheet

    For Each wsSheet In ActiveWorkbook.Worksheets
        wsSheet.Visible = xlSheetVisible
    Next wsSheet
End Sub