Mike - June 2, 2017 Hi Jon, Thanks a lot for your addon, helps a lot. But I would like to ask you for another solution, if you know it. There is a possibility to make a custom ribbon in Word and Excel which is absolutely beautiful. But is there a way to add two buttons for changing font color:. one – black. second – blue This simple thing would hugely improve processes in my company. If you know how to add two font color buttons with different colors, I am ready to pay $10 or more, let us say.
Click with the mouse pointer or use the arrow keys on the keyboard to move the highlight to the desired color in the palette. If using the arrow keys, press the Enter key on the keyboard to complete the color change. In Excel, assigning an alternating color scheme to rows is known as color banding. Start by selecting the cells you want to apply color banding to. Or press [Ctrl][A] to select the entire sheet.
Thanks in advance! Looking forward to hear good news. Rich G - August 9, 2017 A simple way that I’ve used to overcome this is to program two simple macros (Black and Blue) and add them to the ribbon. Just paste these two macros to your personal.xlsb file, add them to the ribbon and change the icons and you should be all set. Sub Blue ‘ ‘ Macro4 Macro ‘ ‘ With Selection.Interior.Pattern = xlSolid.PatternColorIndex = xlAutomatic.Color = 15773696.TintAndShade = 0.PatternTintAndShade = 0 End With End Sub Sub Black ‘ ‘ Black Macro ‘ ‘ With Selection.Interior.Pattern = xlSolid.PatternColorIndex = xlAutomatic.ThemeColor = xlThemeColorLight1.TintAndShade = 0.PatternTintAndShade = 0 End With End Sub You can send the $10 to my paypal account.
– just kidding. January 13, 2017 Hi Bill, Thank you for purchasing the add-in. Not a silly question at all. I thought I had done that, but looks like I forgot to upload the file to the members area. I just uploaded the new file with the button on the XL Campus tab.
You should be able to download and install it. To install the update: 1. Close Excel completely. Download and unzip the new add-in file from the members site. Find the existing Formatting Shortcuts Add-in file (ECFormattingShortcutsFull.xlam) that you saved on your computer. Replace the existing file with the new file. The Formatting Shortcuts button should appear on the XL Campus tab of the ribbon.
The Add-ins tab will not appear unless you have add-ins installed from other developers that use that tab. Please let me know if you have any questions. Thanks again! Juliet - December 1, 2016 Hi Jon, I got it working.
Initially I saved it to a shared drive, but when I saved it to my computer hard drive it started working. It is usful in my line of work however, I am finding that I use this short cut to color coordinate cells, and then when I send my excel spreadsheet via email to a coworker, she reports that the spreadsheet comes in blank, with no highlighted cells. If someone else does not download the short cut then any colors that were established, will they not appear when someone else opens the same document in excel? Noah Browder - May 5, 2016 Hello Jon, I have been searching for this functionality for a long time, very excited to find your add-in. I am running Excel 2016, and I have enabled the Add-in.
When I use the key combination I defined, I get the following message:”Cannot run the Macro “C Users.FormattingShortcuts.xlam” The Macro may not be available in this workbook or all macros may be disabled.” I frequently use macros, so I know that they are not disabled. Can you advise any potential solutions?
Thanks, Noah. April 26, 2016 Hi Steven, One workaround is to create a macro in your and assign a shortcut key to it. The macro could look something like the following. Sub FillYellow Selection.Interior.Color = vbYellow End Sub You would just need to assign a shortcut key to the macro. I did this on the 2011 version for Mac and assigned the shortcut key Cmd+Option+y. Now every time that shortcut is pressed, the selected cells are filled yellow.
I hope that helps. Let me know if you have any questions. I will write an article about it with more details in the future. April 26, 2016 If you plan to use macros or do any type of coding then I would recommend the 2011 version. There are some additional features in 2016 that make it more like the Windows version, but the VB Editor isn’t good for coding and debugging. I don’t use the Mac on a day to day basis, so it’s hard for me to really make a strong recommendation. I have developed VBA projects for the Mac, including my Tab Hound add-in, and 2011 will be the only way to go for stuff like that.
I hope that helps. Gabrielle - September 28, 2015 Hello, I had installed this add-in on my previous computer. I just got a new computer and had downloaded the add-in again, but this time I am getting an error message (on Save&Close) that is not allowing me to use it. It is a Microsoft Visual Basic error: “Run-time error ‘1004’: Method ‘OnKey’ of object ‘Application’ failed. I also noticed that the 1st macro Key (Ctrl+Shift+A) does not have anything selected in the Key field. I tried putting in “a”, “A”, and some other letter, but still was unable to Save&Close.
Have you seen this before, and do you have any recommendations on how to resolve this problem? I like this macro and would like to use it again! August 16, 2013 Thanks Don! You can assign the letter of each shortcut in the Key field text boxes.
These keys are not locked, and you can change it to any letter character. Number characters already have built-in keyboard shortcuts for Ctrl+Shift, so the numbers can not be used. You can also delete the letter in the Key field text box if you want to temporarily disable the shortcut key. I am not sure I fully understand your question, so please let me know if this answers it.
Also let me know if you think of a way that any of the processes can be easier or more intuitive. Thanks again! August 5, 2013 Hi Carlo, I would be happy to help. To change the font or style for the shortcut, you will first need to format a cell with the font type or style you want to use, then set that by clicking the Cell/Format box in the Formatting Shortcuts menu. You will also need to change the Format Type to Cell Style. Here are some step-by-step instructions.
Format a cell in your worksheet with the formatting you want to use with a keyboard shortcut. Click the Formatting Shortcuts button in the Add-Ins tab of the ribbon. In this example we will setup shortcut key #1. The shortcut key should be already setup as Ctrl+Shift+A. Select “Cell Style” from the Format Type drop-down box. Click the box to the right of the Format Type drop-down.
You will be prompted to select the formatted cell. This is the cell you formatted in step 1. Selected the formatted cell and click OK. Then click Save & Close in the Formatting Shortcuts window.
Your keyboard shortcut should now be ready to use. Select an un-formatted cell in your workbook and press Ctrl+Shift+A to format it. Please let me know if this helps answer your question. July 26, 2013 Hi Don, I’m glad you’re enjoying the add-in.
Currently you can only save 3 keyboard shortcuts at one time. This could be expanded to 5. Yes, you can create a shortcut for the center across alignment by creating a cell style with the formatting properties. To apply it to a range, simply select the range and then press the keyboard shortcut. Your selected cells will be formatted with the center across alignment.
By the way, center across is a much better alternative to the more popular merge and center alignment. Merging cells can cause issues when inserting columns or copying cells. It typically requires a lot of extra work to constantly merge and unmerge the cells. It can also cause issues when working with VBA. I much prefer the center across alignment over merge and center. Thanks again, Jon.