Has Excel ever moved or resized comments for you? Would you like to be able to reset to default position, and resize all existing comment boxes to fit the size of your comments? Here is an Excel add In that allows you to select a cell, range of cells, or the used area of the worksheet,… Continue reading Excel Comments Moved Resized Bug
Author: Dario
Customizing Excel Ribbon
Quick Start to adding a ribbon group and buttons, and underlying code to become an excel 2010 add-in. Create an empty folder. EXCELaddins to hold your working files. Within this folder create 2 subfolders named customUI and _rels. Open a new blank workbook. Open the Visual Basic Editor (VBE), try Alt + F11. Create your… Continue reading Customizing Excel Ribbon
R-Value of your Hot Water Tank
Advertised vs. Empirical If you would rather measure, than be given, the R value of your system, you will need to measure temperature. This method of using standby heat loss to arrive at the empirical R value can be applied to many different systems, but here a tank type water heater is measured. Measuring resistance… Continue reading R-Value of your Hot Water Tank
WordPress SubDomain GoDaddy Network Shared Hosting
Herein is the condensed version of installing a (WP) WordPress SubDomain GoDaddy Network on free or shared hosting. This process might be applicable to other shared hosting providers. Shared hosting is economical and will not provide the power required by higher traffic sites. When that time comes you can move to more powerful resources. This… Continue reading WordPress SubDomain GoDaddy Network Shared Hosting
Recover WordPress Network Install How to
So something did not work out with a (WP) WordPress 3.5 Network (multisite) install. Or maybe you want to inspect the contents of another network database. Most WordPress Network databases are recoverable. The road to recovery might seem long and daunting, but if you work through this recovery process, you will gain confidence in yourself… Continue reading Recover WordPress Network Install How to
Reinstall Network WordPress – Save Posts
Have you tried unsuccessfully to Recover Your WordPress Network? Yes, I just want to reinstall the WordPress Network. OK, delete the network tables listed below. If you do not delete any of the Basic tables listed further down, you probably won’t need to reinstall WordPress. Any posts you had on the main site will also… Continue reading Reinstall Network WordPress – Save Posts
Testing URL ReWrite .htaccess or web.config
There are at least two methods to test if URL ReWrite is functioning: Are pretty permalinks working? Break .htaccess or web.config to determine if the web server is processing URL ReWrite. Interestingly, IIS and Apache are subject to the same “break” and both respond with server errors if rewrite is broken. IIS web.config Add some… Continue reading Testing URL ReWrite .htaccess or web.config
Beware Settings->General Site URL, or Site Address (URL)
Changing Your Site URL, or Site Address In Single site mode, WordPress 3.5.1 leads you to believe you need to change the site URL, or ‘Site Address (URL)’ if you want to run WordPress from a folder other than where you installed it WordPress Address (URL) Site Address (URL) On… Continue reading Beware Settings->General Site URL, or Site Address (URL)
How to Create a Development WordPress Site Mirror
Here is one way you can set up and run a development (dev) WordPress site, then move the database to production (prod) without manipulating data. Here’s how the “mirrors” were created. Considerations in Brief We developed on separate hardware for dev and prod, but this method may work just as well on the same machine,… Continue reading How to Create a Development WordPress Site Mirror
WordPress Network Setup Offers Broken URL Rewrite Rules
Conditions: This was repeated with WordPress 3.5.1 installed on shared Linux apache hosting. The hosting account supported multiple domains, with each domain running from a subfolder of the hosting acccount’s web server document root. No attempt to repeat this behavior was attempted with shared Windows hosting. For example, the web server document root was: /some/number/of/folders/html/… Continue reading WordPress Network Setup Offers Broken URL Rewrite Rules