Ribbon button with menu buttons:
1) to apply formatting to selection, active sheet or active workbook (formatting depends of input in cells) and toggle button to enable autoformatting on input.
2) to undo done formatting
2) to open settings form to select font and background colors for formatting
I am an experienced Excel VBA developer, as well as a business consultant. I create advanced Excel-based tools for SMEs and large corporations. I also work with Access, Word, Outlook, PowerPoint and Visio.
I have a master's degree in project management and a bachelor's degree in finance. I worked as an IT project manager and CIO in various manufacturing, retail, real estate development and marketing companies, with anything from 15 to 20,000 employees, before I started my own busine...