customize

  1. J

    Cell Border Color

    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...
  2. M

    customized ribbon VBA

    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!
  3. K

    Customize Cell

    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.
  4. P

    Scoring Stats

    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
  5. A

    Can I recreate Excel 2003 type toolbar and menus in Excel 2016?

    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...
  6. N

    Attempting to customize context menu

    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...
  7. I

    How to disable the Customize Quick Access Toolbar "BUTTON"

    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...
  8. bs0d

    Excel 2013 - Bing Map Customization

    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...
  9. KC Cat

    Excel 2010 Ribbon - Is there a way to show active cell value on the ribbon?

    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...
  10. S

    Column chart - adjustable width of every column?

    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...
  11. 2

    Adding combobox to right-click menu

    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...
  12. T

    Custom Ribbon Icon Auto-Resize

    <!--[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/>...
  13. T

    Create Custome Ribbon excel 2010

    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...
  14. F

    Excel 2010 - How create ribbon icon to open other docs?

    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...
  15. G

    Can you create custom icons for Excel 2010 ribbon?

    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...
  16. A

    How can i emphasize the origin in a graph?

    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.

Some videos you may like

This Week's Hot Topics

Top