customize

I'm trying to customize my toolbar with a button that sets the borders of a cell(s) to thin/grey. To start, I use Format/Cell to set cell border color to grey, thickness to thin, click all the borders. Then.. View Toolbars Customize Commands Format And dragging the Border button to my toolbar...

Hi All, I tried to record macro to set-up customized ribbons. As results, there is no recorded macro. Does that means that we can not customize ribbons by macro or it's only the recording that does not work? Thanks!

Hello - Is there a way to customize a column of cells that requires 9 digits (no more or less) and no dashes? This column will be used to enter social security numbers. I was able to customize no dashes, however, not sure how to require 9 digits in addition to no dashes.

Hello, I am trying to create a final score ie... the team won 2 - 0 or 15 -5, however, I have tried to customize this different ways and Excel keeps defaulting to random numbers. Please enlighten me. Sincerely, Cristine

Hi all, I registered just to ask this question. I considering upgrade to Excel 2016 from 2003. I'm still using Excel 2003, but considering finally making update to Office 2016. The reason I'm still using Excel 2003 is comfort with the toolbars vs. the shock I experienced when trying to...

Hello! I am currently trying to customize the "right click" or context menu for my project in excel 2010. After doing some online research, I was able to come across some code that seemed fairly straightforward to me for getting rid of menu options I didn't want and adding new ones in. My...

Hi All, I have done all the necessary in CustomUI and the VBA; mapping the custom calls to VBA functions. Now the major pain the neck is, the small mischievous Down-Arrow BUTTON ( called as Customize Quick Access Toolbar ) on the TOP LEFT on the title bar of EXCEL, using which anyone can...

Curious if anyone has customized the Bing Map Add-in for Excel 2013? I'm not finding much information on the net. From my observation, you cannot use VBA to manipulate the map. Instead, I believe JavaScript is used via HTML file (somewhere). At any rate, here's what I'm looking to do: • If...

Hello, I used to use a "technique" to add a row at the top of a busy worksheet with a really large font to display the currently selected cell contents. For example, maybe on a vendor contact list sheet with many columns of data that I wanted to see all at once, which made finding and...

Hi guys, I made a normal 100% stacked column based on the following data. Simply select all the cells in the following table, and click 100% stacked column in Excel 2010. Because the A/B/C/D columns they have different weight when it comes to importance. Therefore, I am thinking to make the...

While customizing the right-click menu for cells, I am unable to get a CommandBarComboBox object to show up. Other controls populate fine and no errors are thrown. It is as though the code for adding the combobox is ignored completely. My code is below, any guidance would be greatly...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> <o:p></o:p> I am trying to create a custom Ribbon Tab for Excel, for the purpose of storing all my Macros. I have created the XML code for the ribbon modifications, saved in a text file...

Hello, I've been recently converted from 2003 to 2010. In 2003, I used to have 3 Open icons that were hyperlinked to 3 docs I used daily. To do this, I had to... 1) Right click on toolbar, choose Customize 2) Drag the Open icon to toolbar 3) While Customize window was still open, I would right...

Dear All, Our work just upgraded our computers, our operating system to Windows 7 and Office to 2010. Now the issues are coming to light. I want to use custom icons on the ribbon for my macros. I see you can rename the icons. I see you can change the icon to one of about 100 icons that Excel...

In my y-axis there are values above and below the origin. Is there a way i can make the origin line thicker so that it stands out from the other lines on the y-axis? I hope i've managed to explain. Thanks in advance.