Excel Favorites

This Add-In gives the user a custom favorites ribbon. Key distinctive attributes include dedicated buttons for changing the visibility/sort order of sheets, copying visible cells, Excel\’s camera feature, Snipping Tool, Problem Steps Recorder (PSR) and Windows Calculator. It is written in 3 different versions as a VSTO Add-In in C# and VB.NET as well as a VBA Add-In. The most complete version is C#.

? I\’m currently working on the Web Add-In in JavaScript.

Table of Contents

• Install
• Dependencies
• Glossary of Terms
• Functionality
  • Worksheet
  • Edit
  • Print
  • Program
  • Evaluate
  • Options
  • Annotate
  • Help
  • About

Install

Instructions for installation of VBA and VSTO versions.

VBA

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.

VSTO

How to install the VSTO version

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

Dependencies

Glossary of Terms

Functionality

This Excel ribbon named “Favorites” is inserted after the “Home” tab when Excel opens.

Worksheet (Group)

Save (Button)

• Save (Ctrl + S)

Save As (Button)

• Save As (F12)

Edit (Group)

Undo (Button)

• Undo (Ctrl + Z)

Copy (Button)

• Copy (Ctrl + C)

Cut (Button)

• Cut (Ctrl + X)

Paste (Button)

• Paste (Ctrl + V)

Spelling (Button)

• Spelling (F7)

Print (Group)

Setup (Button)

• Show the Sheet tab of the page setup dialog box

Preview (Button)

• Preview (Ctrl + F2)

Print (Button)

• Print (Ctrl + P)

Program (Group)

New (Button)

• New file

Open (Button)

• Open (Ctrl + O)

Close (Button)

• Close file

Properties (Button)

• Open the properties of the file

Options (Button)

• Open the options dialog box

Exit (Button)

• Exit the application

Evaluate (Group)

Windows Calculator (Button)

• The Windows Calculator runs in standard mode, which resembles a four-function calculator. More advanced functions are available in scientific mode, including logarithms, numerical base conversions, some logical operators, operator precedence, radian, degree and gradians support as well as simple single-variable statistical functions

Calculate Now (Button)

• Force the Calculation. Even if the Calculation option is set for Manual, you can force a calculation.

Annotate (Group)

Excel Camera(Button)

• The camera tool allows you to take a snapshot of any selected range of data, table, or graph, and paste it as a linked picture.
  The pasted snapshot can be formatted and resized using picture tools. They can be copied and pasted into Word and PowerPoint documents as well. The image is automatically refreshed if the data changes.

Snipping Tool (Button)

• Capture all or part of your PC screen, add notes, save the snip, or email it from the Snipping Tool window. You can capture any of the following types of snips:
  • Free-form snip. Draw a free-form shape around an object.
  • Rectangular snip. Drag the cursor around an object to form a rectangle.
  • Window snip. Select a window, such as a browser window or dialog box, that you want to capture.
  • Full-screen snip. Capture the entire screen.

Problem Step Recorder (Button)

• Steps Recorder (called Problems Steps Recorder in Windows 7), is a program that helps you troubleshoot a problem on your device by recording the exact steps you took when the problem occurred. You can then send this record to a support professional to help them diagnose the problem.

Options (Group)

Add-In Settings (Button)

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

Help (Group)

How To… (Button)

• Opens the how to guide in a browser

Report Issue (Button)

• Opens the new issue page in a browser

New Version Is Available (Button)

• This button is visible if the version of the Add-In is different from the one in the Read Me page. It will download a new version from the site when pressed.

About (Group)

Add-in Name (Label)

• The application name with the version

Release Date (Label)

• The release date of the application

Copyright (Label)

• The author’s name