Saturday, March 20, 2010

Excel: Delete All Hyperlinks from Excel Worksheet

Hit [ALT]+[F11] to open the Visual Basic Editor

Go to “Insert” > “Module” and in the pop-up window copy:
Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
Then click “File” > "Close and return to Microsoft Excel"

You can now run the Macro in Excel by going to:

Developer* > Macros > and then Run “RemoveAllHyperlinks”, this will delete all URLS on the selected worksheet.

Big thanks! to Tech-Recipes
*If the "Developer" tab is not showing in your ribbon, here is how to get it to display 
Creative Commons License 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/.

Tuesday, March 16, 2010

Google Reader - The fix for: You don't have permission to view this feed

Here's how to fix "You don't have permission to view this feed" in Google Reader:


"Something on your computer or network (proxy/firewall/antivirus/etc) is probably interfering with Reader's access to the internet when you use http. Since https encrypts the data, it is less likely to be stopped by these programs. In general, if you find that you are unable to access Reader with this kind of error, try using https first."


Simply replace http:// with https:// in the address bar.  It works!


Thanks to Brian Shih, Google Employee:
http://www.google.com/support/forum/p/reader/thread?tid=3b5e82d12b9a35c2

Wednesday, March 10, 2010

Outlook 2007 - Rules aren't processing correctly

Be sure to check the "stop processing more rules" after entering your Rules Wizard criteria.  If you don't check that box then you'll either get duplicate email messages in your folders, or the rule won't work at all.  This works differently than in Outlook 2003, Outlook Express, or Windows Mail.

You'll see "stop processing more rules" after the clicking Next under "What do you want to do with the message?"

Wednesday, March 3, 2010

Outlook 2007 - How to send an Email to all Contacts in a Specific Category


To send email, set up a meeting or task, or write a letter to all the Contacts in a (color coded) category:
  1. In Outlook, go to your Contacts section.
  2. From the View menu, select Current View, and then By Category.
  3. Highlight the category you want to send email to by clicking it.
  4. In Outlook 2007, from the Actions menu, select Create, and then New Message to Contact. In Outlook 2000, 2002, or 2003, from the Actions menu, select New Message to Contact.
Related Posts Plugin for WordPress, Blogger...