Flash has been popular format for desiging interactive games, navigations, media, movies, and animations for the world wide web. You can actually download these files and keep it as your belonging for your viewing or playing pleasure. The following methods shows how you can save flash files no matter which browser (Internet Explorer, Mozilla Firefox, or Opera) you are using. [Read more…]
Mobile Friendly Blog Feed in Google Reader
Mobile phones has long been able to browse websites. If you’re not making your site accesible and viewable by mobile devices, you are potentially losing some valuable visitors.
A fast and easy way to test how your feed will look like in a mobile device’s screen is to use Google Reader. Google Reader can generate an excellent mobile view of your RSS feed in less than 10 seconds. Just append your feed address to the following URL [feed_address_here] and your mobile blog is ready to be served.
http://www.google.com/reader/m/view/feed/[feed_address_here]
For an example, this is what my blog’s feed will look like
http://www.google.com/reader/m/view/feed/http://feeds.feedburner.com/davidtan
How To Protect, Hide and Unhide Excel Worksheet
It’s easy to protect excel worksheets by hiding it and equally easy to unhide it as well.
How to Hide
1. Select a worksheet
2. Goto Format > Sheet > Hide to hide an entire worksheet.
How to Unhide
1. Goto Format > Sheet > Unhide and select the worksheet you want to unhide.
As you can see, unless you protect the worksheet/workbook, anyone can select Format > Sheet > Unhide to see the hidden sheet.
A Better way to Hide (Without Password)
You want it, so here’s another option:
1. Press Alt-F11 to display the Visual Basic Editor
2. In the Project window, expand the folder Microsoft Excel Objects, and select the sheet to hide.
3. Press F4 to display the Properties window (if it’s not already shown)
4. Set the sheet’s Visible property using the drop down box to 2 – xlSheetVeryHidden.
5. Users won’t be able to unhide the worksheet such as using Format > Sheet > Unhide as it won’t be listed anymore on the list of hidden worksheets.
5. Again, there’s still workaround to unhide the sheet, if the user knows how. To unhide the sheet, repeat these step, but set the Visible property to 0 – xlSheetVisible. Let’s just assume that less people knows about this and thus it’s a bit safer than the previous option.
Best way to hide and protect
Just protect your worksheet/workbook under Tools > Protection… and set a password for it.
Simple Way To Block Websites
To block websites on your home computer without spending lots of money in expensive software, here’s a trick for Windows PC. [Read more…]
Outlook 2007: Adding Outlook URL Protocol
If you are using Office 2007 then you will probably need to enable the Outlook URL protocol handler so that hyperlinks to mail messages, contacts, events, etc work. It was initialized by default in previos versions of Outlook, not sure why they left this out in Outlook 2007. [Read more…]
Create Hyperlinks to Outlook Messages, Folders, Contacts and Events
The Windows operating system recognizes the outlook: tag and whenever it sees that it’s part of a link, it triggers outlook to do something. Depending how you format the hyperlink, you can open messages, folders, contacts and meetings stored in outlook from websites, documents (Word, OpenOffice etc), Excel spreadsheets and powerpoint presentations stored either locally or even over a shared network. [Read more…]
PHP Array Fatal Error
I’ve been using this code for quite a long time and it has been working for me most of the time. What it does is that it reads a directory (“uploads” in this example) and store every sub-directories that it can find into an array $year[].
$dir = "uploads";
$yeardh = opendir($dir);
while (false !== ($yeardir = readdir($yeardh)))
{
if ($yeardir != '.' and $yeardir != '..' and strtolower(substr($yeardir,strlen($yeardir)-3,3)) != '.db')
{
$year[] = $dir.'/'.$yeardir;
}
}
closedir($yeardh);
It was only recently that I tested and found out that it failed under “certain circumstances” showing the following error message.
Fatal error: [] operator not supported for strings in file.php on line xx
How To Merge Excel Cells
The act of bringing two or more rows/columns into one is known as “merging” in Excel. Here is a fast way on how to do that. [Read more…]
Excel: How To Add Line Break In Cell
Most text editors moves to the next line when you press ENTER. What you have done is essentially entered a line break.
However, things work a bit differently in Microsoft Excel. Instead of entering a line break, Microsoft Excel jumps to the next cell when you press ENTER.
The solution is: Use ALT-ENTER if you want to achieve a line break in a Excel cell.
Simply put:
– You are adding a new line to the text in a cell when you press ALT-ENTER.
– You are jumping from one cell to the cell in the next row when you press ENTER
Web Developer Tools Roundup
As a web developer, you definately find times when you found a cool webpage and wonder how they did it. You wonder if there’s a tool that can show you in real-time what is happening or let you access the properties, attributes, HTML, CSS, DOM, JS of a page. Bear in mind that I’m not talking about what happens in the backend like server-side scripting language (Perl, PHP, ASP, CFM and JSP) and database access but more into the looks and user interaction (which i would refer to as the frontend). [Read more…]