This Add-In is used for marking up Excel files with revisions. There are two common methods of indicating where a revision has changed a drawing that contains a system diagram. The first is the cloud method, were each change is enclosed by a cloud shape. The second method involves placing a triangle with the revision number next to each effected portion of the drawing. The cloud method indicates changes from the most recent revision only, whereas the second method indicates all revisions to the drawing because all of the previous revision circles remain on the drawing. It is written in 3 different versions as a VSTO Add-In in C# and VB.NET as well as a VBA Add-In.

• Install
• Dependencies
• Glossary of Terms
• Functionality
  • Select Markup Color
  • Insert Revision
  • Insert Markup
  • Insert Cloud Part
  • Edit Markup
  • Help
  • About

Instructions for installation of VBA and VSTO versions.

How to install the VBA version

1. Download the VBA Add-In file .
2. Copy the file to the XLSTART folder on your computer. %AppData%\Microsoft\Excel\XLSTART\
3. Close all open instances of Excel and then launch Excel. The new ribbon should appear.

How to install the VSTO version

1. Download AnthonyDuguid.pfx And Install At Root Level
2. Download and run the setup.exe file.

This Excel ribbon is inserted after the “Home” tab when Excel opens. Listed below is the detailed functionality of this application and its components.

• Select a color for the Markup shapes

• Select a standard color for the Markup shapes from the list

• Update the color for the selected shapes

• This character will appear in the middle of the triangle

• Insert a revision triangle in the area of the selected cell(s)

• Insert a cloud in the area of the selected cell(s)

• Insert an inverted cloud in the area of the selected cell(s)

• Insert a cloud with hatching in the area of the selected cell(s)

• Insert hatching in the area of the selected cell(s)

• Insert a cloud part on the Left of the selected cell(s)

• Insert a cloud part on the Right of the selected cell(s)

• Insert a cloud part on the Top of the selected cell(s)

• Insert a cloud part on the Bottom of the selected cell(s)

• Join objects together to move and format them as if they were a single object

• Remove the last shape created

• Remove all Markup shapes from the active worksheet

• Opens a webpage of the read me documentation

• Opens a page to create a new issue for the product

VSTO

• Types of VSTO Settings
  • Application Settings
    • These settings can only be changed in the project and need to be redeployed
    • They will appear disabled in the form
  • User Settings
    • These settings can be changed by the end-user
    • They will appear enabled in the form

VBA

• VBA Settings
  • To add a new setting

    ThisWorkbook.CustomDocumentProperties.Add _
    Name:="App_ReleaseDate" _
    , LinkToContent:=False _
    , Type:=msoPropertyTypeDate _
    , Value:="31-Jul-2017 1:05pm"

  • To update a setting

    ThisWorkbook.CustomDocumentProperties.Item("App_ReleaseDate").Value = "31-Jul-2017 1:05pm"

  • To delete a setting

    ThisWorkbook.CustomDocumentProperties.Item("App_ReleaseDate").Delete

• The application name with the version

• The release date of the application

• The author’s name