add in

To run a macro from a hyperlink, code below is used. Cell with hyperlink is named, then right-click, Link, Place in This Document, choose named cell. It works in workbook with code, why doesn't it work from add-in? 'CODE IN WORKSHEET Private Sub Worksheet_FollowHyperlink(ByVal Target As...

I'm doing some research on stock prices. I'm using the AlphaVantage add-in (Excel Add-on | Alpha Vantage) to source the price history. Currently I have 13 sheets of stock data with about 5000 lines -- large, but nothing extraordinary. Most of that space is populated by an AlphaVantage call in...

Hello, I am trying to use Power View so I went to activate it by going to the COM Add Ins but I don't see it listed. How do I get it to show up so I can turn it on? Thanks!

i have excel add in, but now i want to convert it in to com addin, can some one give me suggestions that how can i proceed where can i get help. thank you.

A couple years ago I came across an excellent utility (free also...) that would go through my code and provide a report that included all the variables I created while I was stumbling along and ended up not using, but I can't for the life of me recall the name of it and no longer have access to...

Problem Date and Time Picker & Monthview controls are not included as a standard since Excel 2010 (additionally there are some known issues). So the additional controls are buggy (>download< - >step by step<): Microsoft Date and Time Picker Control 6.0 (SP6) Microsoft MonthView Control 6.0...

Storm.ExcelMacros Suspicious unknown excel Add-in found Last week running a macro that normally takes 1 min, excel became trapped in a loop “round blue circle still showing in the screen and performance monitor shows processors still working even when I knew the macro was done”. Troubleshooting...

Hi I made add in in vba that include form.I want that the form retrieve cell content into textbox of the form if the user press on column B in the workbook. So, I worte the sub Workbook_SheetSelectionChange inside ThisWorkbook but after I saved my worksheet as .xlam file the sub...

Hi, I am currently running the 64 bit version of excel 2013. Are you aware of any add in like ASAP utilities that will work with this version? I am looking for the date fixing feature in particular. For instance, 12-03-2014 would show u in my data as 12/03/14 or 12.3.2014 ASAP utilities fixes...

Hello, I would like to create a ribbon add in for my computer to use their custom color palate. Does anyone know a good resource to walk me through how to do this. I have used VBA extensively and consider myself to be a professional novice. Thank you. FC

Hi, I developed an add in and just wondered where the best place in forum may be to announce it. Cheers Vince

I have created a workbook with all my macros and saved as an add-in (.xlam) but I am now struggling with deployment and ui customization. I know how to modify the ribbon for my own excel but I want to create a full add-in that I can distribute to my colleagues that has a new custom ribbon tab...

I need your help in creating a distributable add in which will help me post either one or many URL's (predefined by me) to outlooks favorites section. I.e. when I distribute this add in to the user and the user runs it, the url's should be posted to the favorites i.e. the user should be able to...

Does anyone have experience using add-in's with Excel for Mac?

using excel 2010 I am attempting to create an addin that will allow a user to input information into a userform and then search a Source Workbook for a matching entry and copy it into the current Workbook. I can get it to work by opening the Source Workbook and copying the sheets and entries...

hey, I am trying to create an Add-in function to my excel sheet. Basically, I need it to say =if(isna(vlookup(Lookup_value,Table_array, Col_index_num,[Range_lookup])),"0",vlookup(Lookup_value,Table_array, Col_index_num,[Range_lookup])) . I have been manually typing this function in when I...

Hello, I have this situation at my work place: -there is an big add-in that is frequently being updated by someone else (uninstalls add-in and re installs it, and creates an excel menu so the users can handle the macros easier) -i have been asked to create a separate add-in, but with references...

Has anyone ever tried E Table Utilities? A friend of mine asked me about it recently and I hadn't heard of it. I'm wondering if there is any positive or negative feedback I can pass along to my friend. http://www.etableutilities.com/

I've made an Add-In to hold all my formulas for, say brick coursing. I then made a name range in the Add-In to contain the names and dimensions of all brick types. So far so good. I make a new spreadsheet, enable the add-in, the functions work, except... I click on a cell, enable data...