LinkBack URL
About LinkBacks
Dear All,
I try to add add ins tab to the ribbon. i checked in customize ribbon. it is not coming. could some one please help me.
Regards
sunil
Dear All,
I try to add add ins tab to the ribbon. i checked in customize ribbon. it is not coming. could some one please help me.
Regards
sunil
I don't believe the ribbon is customizable in Excel 2007. Do you have Excel 2010?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks for your response.
Please see the attached file for your quick understand of my issue.
I dont have 2010 office
Okay, that's different, you're trying to customize the QuickAccess toolbar. So when you go to "Add" those individual items from the Add-in Tab, and you press "OK" they don't appear in your QuAccess Toolbar? or they don't work properly when added?
First, i would like to have Add-in Tab on tool bar. After that I will add My own macros to run on that.
Not sure. I found this thread. Does this help?
http://www.pcreview.co.uk/forums/add...-t3372660.html
I read all forums on this issue. No solution found. Surprisingly, Now i installed office 2010. It is also not showing the Add-in tab.
Trying to get rid of this issue since 8 hours. solution is nothing.
Was this ever solved by someone else? Sorry if this is redundant but I did not see it presented.
The user does not "create" the tab then add controls to it, the Add-Ins tab will only show if
(1) it is enabled in the user's Customized Ribbon Options AND
(2) A control has been added to it, for some add-in, at one time (and was not temporary / removed since).
I think a risk might exist if on the ThisWorkbook Open event of the add-in, you don't remove the control(s). That will leave the commandbarcontrol in the Add-Ins menu, whereas the functionality it invokes is not viewable from the VBE without running it - not cool, in my opinion. (Choosing the menu item would cause the add-in to open, but the user might click no to running macros.
I suggest putting code to remove the menus for any add-in being closed in the Workbook_BeforeClose event *in addition* to making the menu items temporary while being created. If there were a Workbook_Close event, of course I would suggest using it ... but no such event exists. The closest is the Workbook_BeforeClose event. I don't think that the rish an add-in, which usually is not written to by the user, will be reached without the add-in going all the way to being closed. But it is worth taking into account the possibility that it stays open, with no Menu items in view.
You can also remove the controls in the Workbook_AddinUninstall event, but this should be in addition to the Workbook_BeforeClose event of the add-in, because closing an add-in does not uninstall it.
The code to add, you probably already have, but here is an example, on Add-in Open
In the Add-in's Module1, this sub (assuming I have a userform named frmMonitorWorkbooks to show:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mrbillbenson; 03-17-2014 at 12:39 AM.
Even i have similar issue with my VSTO Add-in. The add-in loads only for new file but not for existing files. What may be the reason for this kind of behavior?
After restarting the machine, issue gets resolved. But after some time, again add-in wont load for existing files.
Tool usage: Visual studio 2010, MS Excel 2010
Registry: HKCU
Kindly help me out, please..
I have Excel 2010 and had the add-in tab appear only in the instance in which I installed it. Every time I would close and re-open Excel, the add-in would disappear. I tried all types of suggestions - and finally found one that worked for me!
Go to the add-ins folder where you have your add in saved. Right click on the file, and select Properties. At the bottom of the General tab - if it says "Security" - check on the "Unblock" option.
Voila! My add-ins never disappear anymore!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks