The tools support the 32bit versions of Office® 2010 and higher. The tools do not support Office® for Mac.
Yes. However, most of the actions of the Helpers themselves can be reversed easily, but you do lose pre-previous steps of the undo button (undo stack) in any case. In order to be able to go back to the previous state, you can save your file prior to executing the code. Thus, after running the code and not wanting its results you can discard the changes by reopening the file without saving.
No. The add-in will open, but will not install properly. Follow the steps in the tutorial to install the add-ins properly.
An Office Update of July 2016 is causing issues, by requiring extra security from files that have been downloaded from the internet. Now, add-ins only execute when stored in "trusted locations".
The Planning Helper Install Add-ins Helper is designed to deal with this issue. You can select add-in files from any location and the Install Add-ins Helper will install a workable add-in in and place it either in the user's default add-in folder or into a folder of the user's choice.
Three options to manually deal with this issue:
Links to further help:
Planning Helpers are VBA add-ins and come in the regular add-in file formats: .xlam (Excel) and .ppam (PowerPoint). For the set-up you do not need admin rights.
It depends on your version of Office
Excel 2016 - C:\Users\"user name"\App Data\Roaming\Microsoft\Addins\
Excel 2013 - C:\Users\"user name"\App Data\Roaming\Microsoft\Addins\
Excel 2010 - C:\Documents and Settings\"user name"\Application Data\Microsoft\Addins\
Like any other VBA add-in: untick the add-in name in the menu and delete the .xlam file in the Office add-in folder.
The Color Coding Helper works with all the regular chart types used in business:
Not workable chart are:
The Color Coding Helper reads colors from a chart to a cell range and back. Thus it can only deal with the colors that can be applied as background colors to cells. These are plain colors, not with color gradients and not colors with transparent color.
Use the 'redo labels' button.
The 'alt text' in Excel consists of 'alt title' and 'description'. These properties' original purpose is to describe the image textually so that search engines and screen readers (software used
by the visually impaired) can understand what the image is. This is only rarely used, for instance when publishing an Excel sheet in HTML to the web. Hence, we can safely use this feature for our
purposes, e.g. forassigning to an order to charts in a workbook or for storing a chart image's meta information, such as source file name.
Find more on Microsoft Office Support net.
This is a rather rare event. Typcially it occurs with workbooks that have been saved in older versions of Excel before (e.g. created in 2010, saved in 2007, reopened in 2010 --> error).
You can usually workaround this by moving your data into created workbook.