Posts

Showing posts from 2014

Columns side-by-side or stacked -- CSS to adjust for screen width

Image
I recently had to brush up on my CSS skills to develop a solution where two buttons would appear side-by-side unless the viewport was less than 480 pixels, in which case they should then display stacked. Through a bit of research, I found a couple of solutions. When I tried to implement the solutions as presented, the buttons didn't appear side-by-side, but instead on separate rows -- I'm sure something I must have overlooked, but nevertheless, I, therefore, came up with my own modified solution.

My particular example used 3 columns -- the middle just for space, which could be done with padding and/or margin. The key is using "@media." By default the widths of the columns were all set for 100% -- configured for stacking. When the screen was 480 pixels or larger, using "@media" the widths are adjusted 45%, 10%, and 45%. If you're not sure what each of these CSS properties does for you, try searching "css [property]" such as "css clear&quo…

Comcast will use your service to offer WiFi to other customers

Image
Yes, you heard that right! If you're a Comcast customer and you rent a cable internet modem from them, then it has a separate wireless channel that other Comcast customers can use. This means as a Comcast customer, you can surf the Internet from any neighborhood where Comcast has an install base.

While in theory I like the flexibility as a Comcast customer to get WiFi anywhere (Xfinity WiFi Hotspots), in practice I'm not too pleased.

Why I'm not pleased.I pay Comcast to have their Internet service, which enables this capability.I pay another $8 to rent their modem, which is also required for this capability.I was never asked; my account was opted-in.If I have an issue with my connection, I have to hold a long time (typically), and if something is wrong at my end, I have to pay for them to correct, yet again Comcast benefits from my service working.If you live in an apartment complex, Comcast advertises your apartment complex on the list of available hotspots (mine shows up…

Firefox Status Bar gone missing? Let's bring it back!

Image
With the release of Firefox 29, the Status Bar workaround no longer worked. I don't recall when it stopped displaying, but now there's no option. I found a handy add-on that brings back the Status Bar, Status-4-Evar, so my other add-ons display again.



Remove all hyperlinks within Excel

Image
Ever copy a webpage of data into Excel, and it brings along a bunch of hyperlinks? Of course, it isn't practical to remove each hyperlink manually. Fortunately, there are a couple of options to perform a bulk removal of hyperlinks.
Note that I'm using Excel 2007 in my examples.


OPTION 1Select the cells that contain hyperlinks.On the Home tab, in the Editing section, click the Clear drop-down arrow.Click Clear Hyperlinks. I have found in some cases that the Clear Hyperlinks option isn't available. In those cases, use option 2 below.

OPTION 2 Use the following macro: Sub NoMoreHyperlinks()

ActiveSheet.Hyperlinks.Delete End Sub For those of us that need a reminder on how to create macros, here's a more detailed process.
Press Alt-F8 to display the Macro dialog boxEnter a new macro name (such as "NoMoreHyperlinks") in the text box just below "Macro name:"
- This will change the Create button from an inactive to active state
- If you already have one or more …