toolbar

I have a bespoke ADD IN (called GET DATA). I am trying to add this so it is shown in a Separate Tab on the ACCESS TOOLBAR but it will not show. On some machines it works and shows but this machine it does not. Any help much appreciated.

Hi guys, How do I assign an icon to a command that does not have an built-in icon ? Excel always uses the green circle and the option to Modify is grey out. I'm using excel 2010. Thanks

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

Hi, I had a look, but am unsure how to word this question, so no luck in finding it in the forums. If it does exist! Usually when I click on a tool in the toolbar. Eg. fill, text colour, border - something with a drop down list it selects the last used function. Eg. Fill in red. unless I click...

I am trying to share a custom Excel 2010 ribbon tab, but everytime I export and the other user imports, it overides their quick access toolbar as well. Is there any way around this, or do I just need to setup the quick access toolbar again? Thanks!

Apologies if this has been asked for already. Can you please put the code formatting buttons onto the Quick Reply toolbar? This would make it easier to format a code sample when I'm typing a response without having to switch to the full editor. Thx, Jimmy

I am working on a new workbook to handle data in a very specific way. AS a result I am trying to limit the options available to the users, and programmatically force proper behavior. Since I don't have enough free time to smack knuckles with rulers as appropriate. I have successfully...

greetings, i just finished working on a custom toolbar within a workbook for excel 2010. however, when i tried to add multiple buttons and open the file, i got an error message saying: "Multiple custom UI parts were found in the file. Only one part is expected." Is there any way to fix...

Hi I have a fairly large (33Mb) and complex workbook which has stopped allowing me to trace dependents on some formulas. Trace precendents is still working however. Note that this isn't that the functionality is 'dimmed', it is that the application states that there are no dependents when...

I have a custom toolbar in a spreadsheet that is used by many different people. The toolbar has a single button to trigger a macro that inserts unlocked lines in a protected workbook. The custom toolbar shows up when the file is opened on my machine (Win XP, Excel 2003), but it will not show...

Hi all, Have just had Excel 2007 installed next to 2003. I used to have my "own" toolbar with icons I desinged myself for a specific action and used the different coloring to make things clear. They now safely appear in my addins ribbon or something imported via Personal.xls Is there anyway I...

I am having a probelm with macros assigned to a custom toolbar. I am using excel 2003. 1. I have created several macros in a workbook named "PLAN" 2. I then created a custom toolbar. 3. Through the customize dialog box, I assign the Macros to the custom tool bar button. Everything work fine...

If I have six cells with numbers in them in one column and I go to autosum those six numbers, the formula will be correct and sum correctly, but the formula will not show up in the formula toolbar. It just appears blank. I am happy to email a screenshot to someone if need be.

I have macros buttons on the 2007 toolbar that sometimes don't work. I know it's because sometimes I'm opening a 2003 file that someone has sent me or sometimes I'm opening a 2007 file that someone sent me or I've created. How can I get the toolbar button to use the macro from either personal...

Hello, I am new in VBA programming. I would like to transfer a very simple macro to define the worksheet header and footer. To do so, I have created my own tool bars. I also want to send this macro as an Add-in. My question is; how to tell the macro to display the tool bars when the add-in...

In Excel 2003 there was a Web-Toolbar, 2007 it looks to be lost.:eeek: This is very helpful when using paths to link to docs from other docs. Any help would be greatly appreciated! :)

Hi, I'm trying to set up 2 different print toolbar buttons, each mapped to a separate printer. Is this even possible? The one that is on there maps to my default printer and prints when pressed, but when I add the second toolbar button I can't find anywhere that allows me to change the...

I Customized a Toolbar and attached it to a form using the form.toolbar property. I also, defined the first form to load, Now if I open the MDE file using the Access 2003, the toolbar appear when the form is activated. if I open the same MDE file, in the same computer, using RUNTIME 2007, the...

I use excel so much, that in excel 2003, I had created macros, all they did was open a particular file, and then i created custom toolbar buttons, so that for each file that I used often, I had a toolbar button that if clicked, would open a file. when I started using 2007, on the addin tab, my...

Can any one please let me know how I can hide all the tool bars/ Menus in Excel, except the one I created for myself. The tool bars must remain hide untill I close this workbook.