How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jess M. Your Own Question

Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 4309
Experience:  Computer Software Specialist for more than 10 years
49766785
Type Your Microsoft Office Question Here...
Jess M. is online now
A new question is answered every 9 seconds

I have lost a toolbar in the addins tab Custom tool bars is

Customer Question

I have lost a toolbar in the addins tab Custom tool bars is there any way to get it back
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Chris L. replied 1 year ago.
Hello and thank you for using Just Answer. My name is Chris and I will be happy to assist you.

I am sorry to hear you are having trouble.

Is this a toolbar in internet explorer that you have lost? Please tell me which tool bar you are missing.

Thank you,
Chris
Customer: replied 1 year ago.

It is in MS Excel 2010 the "Addins" tab in the Custom Toolbars secion. It is an XLA (Addin Toolbar)

Expert:  Chris L. replied 1 year ago.
My apologies but I am not sure at this time . I will opt/out and send your question back to the other experts. You will receive an email when they are ready to help you shortly.

Thank You
Expert:  Jess M. replied 1 year ago.
Hi, welcome and thank you for your question. My name is Jess and I am glad to assist you today.

Can you please describe "where" did you first "have" this "Add-ins" tab? Also, you mentioned this is an XLA file, can you please tell me which Add-In is this? (Like "TreeMapper" add-in)


Best regards,
Jess
Customer: replied 1 year ago.

The Addin Tab is in the ribbon in Microsoft Excel 2010 and 2007. The XLA file is an Addin containing Macros to assist in Finding and sorting files/


Attachments are only available to registered users.

Register Here

Attachments are only available to registered users.

Register Here

Attachments are only available to registered users.

Register Here
View Full Image

Attachments are only available to registered users.

Register Here


To get your addins tab to show Right Click on the Ribbon and Click on Customize Ribbon and make sure there is a check mark in the Addins Tab.


 

Expert:  Jess M. replied 1 year ago.
Thank you for writing back with that information. So the Add-Ins tab is in the "Main Tabs" since it has the FIle and other menus.

Now, do you know the what software did you install to bring this add-in or XLA file? Or can you please tell me the exact filename of the XLA file?

If you are using Windows Vista or 7, please visit this path to see if your XLA file is there:

C:\Users\your-user-name\AppData\Roaming\Microsoft\AddIns
(your-user-name is your Windows login name)

Jess
Customer: replied 1 year ago.

I gave the file the name finder_1030.xla it is located in the ...\Addins section as it should be.

Expert:  Jess M. replied 1 year ago.
Thank you for that information.

First, please do the following:

A. Ensure that Add-Ins is listed under Main Tabs
  1. Open Excel
  2. Click on File => Options
  3. Click Customize Ribbon in the left menu/panel
  4. In the Customize the Ribbon selection box at the top, select "Main Tabs"
  5. It shall display the contents of the Main Tabs which includes "Add-ins"
  6. Here is my screen shot:

    Attachments are only available to registered users.

    Register Here

    Attachments are only available to registered users.

    Register Here

    Attachments are only available to registered users.

    Register Here
    View Full Image

    Attachments are only available to registered users.

    Register Here

  7. If Add-ins is not checked, click on the check box to put a check mark on it
  8. Then click OK

Now, if Add-ins is already checked there, do the next steps:

B. Enable the Add-ins (Manually)
  1. Open Excel
  2. Click on File => Options
  3. Click on Add-ins in the left panel
  4. In the selection box in the bottom named Manage, select on Excel Add-ins
  5. Then click on GO button
  6. Here is my screen shot

    Attachments are only available to registered users.

    Register Here

    Attachments are only available to registered users.

    Register Here

    Attachments are only available to registered users.

    Register Here
    View Full Image

    Attachments are only available to registered users.

    Register Here

  7. In the list of Add-ins, please check if the Add-in represented by your XLA file is listed there. If it is, you can simply click on the check box to enable it.
  8. Here is my screen shot:

    Attachments are only available to registered users.

    Register Here

    Attachments are only available to registered users.

    Register Here

    Attachments are only available to registered users.

    Register Here
    View Full Image

    Attachments are only available to registered users.

    Register Here

  9. When a check mark is put next to the Add-in name, it means enabled. When your plugin is there and checked, click on OK
  10. However, if your Add-in is NOT listed there, click on the BROWSE button in the dialog box I showed above
  11. Now, go to the location of the XLA file, you mentioned it is finder_1030.xla. Please locate this file when you click the browse button.
  12. Then click on it when selected
  13. Then click OK to enable it
  14. Then see if the Add-ins tab will now show in your menu, the Main Tab

Please remember to rate my service positively (3-5 stars/faces) once you have all the
information you need.

If you have any other questions, please DO NOT rate my answer negatively (1-2 stars/faces). Instead, please ask me or reply to me – I’ll be happy to respond.

Thank you!

Best regards,
Jess

Customer: replied 1 year ago.

Yes I have done all of the things you have mentioned above and Is has not done any good the tool bar still does not show up.


I have gone into the Code in VBA and made sure that the Toolbar is set to Visible = True. In fact I have manually set the toolbar to Visible = False then reloaded the toolbar and nothing shows up. I then go back into the code and Set the Toolbar to Visible = True, remove the Tool bar and reload it and it still does not show up.


 


All of my other toolbars are in the Custom Toolbar just not this one. I was hoping that someone had dealt with this before but I can see that it is not so.

Expert:  Jess M. replied 1 year ago.
Did you create this XLA file yourself?
Customer: replied 1 year ago.

Yes I created it and it was working fine until it was deleted off the Custom tool bars of the Addins tab.

Expert:  Jess M. replied 1 year ago.
Can you send the file to me so that I can check it manually? If it is possible, you can upload the xla file to this site below:

http://wikisend.com

No need to register there. Just upload then wait for the screen to show the 6-digit File ID. Post the file ID when you reply so that I can download the xla file.

Jess
Customer: replied 1 year ago.

No the issue is not with the XLA file rather it is with deleting the file from the Excel Program. I have the program working on 6 other computers with no issue.


 


If you don't know of a way to make Excel show the addin that is fine. I will simply do the work on a different computer.


 


Thank you

Expert:  Jess M. replied 1 year ago.
The procedures I gave you should make the XLA work. It is how to install an add-in of type XLA. It is basically pointing to the XLA file using the browse button in the Add-ins dialog box and checking it in to enable the add-in.

You mentioned "deleting the file from the Excel program". How did you do it? Did noy move this xla file from its location when it was first installed?
Customer: replied 1 year ago.

Well the procedures did not work and I had tried all of those before I even went to the internet.


To delete a toolbar right click on the toolbar then left click on "Delete Custom Toolbar" and it will be gone.


 


I have found a solution on my own so I consider this matter closed.

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions