add-ins

I use Add-Ins all the time and have the folders all added to the The error I am getting is "Cannot run the macro " xxx Macro Location xxx". The Macro may not be available in this workbook or all macros may be disabled." I developed the macro and add-in on this machine, and have used it...

Team, I'd like to view several sheets at the same time. Is it possible to (via an add-on or maybe in version 2010) to view several sheet in separate 'panes'. Consider MS Access, how tables can be opened either with tabs across the top or with overlapping panes. In a model I'm building I'd...

Hello Mr. Excel Community, I have experienced the following problem using Excel 2007 under Windows XP. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have a VBA library (library.xlam) that is used by a client Excel app (client.xlsm), both stored in a...

Hello, I feel silly asking this, but I'm looking for help locating an add-in that I know I've seen, but cannot find again. I'm pretty certain it was free too. One of the features of this add (for 2007 btw) was as a replacement for the recent documents list - it allowed for storing more...

Hi everyone, I have this user defined function (UDF) add-in (.xla) that has worksheets in it. How do I make these worksheets viewable in an Excel workbook so I could put values and make use of it? TIA

Ok, I created a macro and saved as an add-in in 2003 then put a button on the toolbar to run the add-in, easy. Problem put the add-in on another computer running 2007, can't create an icon/button on the quick access toolbar in order to assign the add-in to it. Since it's not as easy as right...

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

I've written a bunch of functions I'd like to spread with my coworkers. Knowing most of them don't know how to install an add-in manually I was thinking if this could be done with a macro. I'm thinking something along the lines of sending them the functions as a normal worksheet with a macro...

Hello, I have recently discovered the beauty of add-ins, but I've got a small problem : I saved my add-in workbook as an xla in the appropriate folder and I enabled the add-in in the workbooks, but when I open a new workbook, the sub I had made does not appear in the Macro's list (Alt+F8)...

Hi, I've emailed a workbook through to a new computer (which has the same 2003 Excel edition) and the dates aren't recognized correctly, in my formulas, expressing a '#VALUE!' message, instead! Any way to get round this? I've tried clearing the contents and reformatting the cells affected, but...

It is common practice in my office to create Excel spreadsheets using functions from a custom add-in. Every user has a copy of the add-in on their computer. We often encounter the problem where links are introduced into the Excel worksheet, so that the user is prompted to Update Links whenever...

Greetings all I have up to now made extensive use of three third-party add-ins, while using versions of Excell up to Office 2003. In each case the add-ins had cross-version compatibility up to that version. The three add-ins to which I refer are: Bill Manville's "FindLink" Jan Karel...

Hi, I am in some major need of help. I'd like a macro -- actually a plug in/add-in if that can be set up -- that finds the maximum DPI print quality setting of a worksheet within an Excel workbook (this is the setting under File | Page Setup | Page tab | Print Quality), and will take that max...

I think Laurent Longre's moregfunc is great and it is often referred to on this forum. I am using Longre's MCONCAT extensively in a spreadsheet I am building, it could be said to be the centre of the spreadsheet's functionality. A few nights ago (Western Australian time - Tue 3rd...