Month: April 2015

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

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