1. L

    Send message pop up on another computer via Lan network from Excel

    Hello guys, I have a question about how to send message pop up to another computer via Lan network from excel. I can not figure out the solution. Just found the way to send email. But I would like to send message pop up via any suitable softwares using Lan network (e.g. Stickies software)...
  2. JenniferMurphy

    How to assign add-in code to a control button

    I have been testing a macro that I have assigned to a Button control in an .xlsm workbook. Now that OI have it working, I'd like to move it to an add-in module to other workbooks can use it. But once I move it to the add-in module, where I have lots of UDFs, the Assign Macro dialog doesn't offer...
  3. C

    VBA Code Works in

    Hello All! I'm attempting to copy several workbooks in a folder into one workbook. The code works when the spreadsheet is saved as a .xlsm. However, when I save the exact same code as Excel Add-ins, I continually get the following error: Run-time error '1004'": Copy method of Worksheet class...
  4. M

    Macro to populate username and password in 3rd party add-in pop up

    Hi All I use a 3rd party add-in in Excel and every time I start Excel, I have to manually add the password etc. I tried recording the process but the macro recorder does not recognise the login pop up. Is there any way I can do this so I can create a shortcut button that will launch the add-in...
  5. pedrowave

    New Rolling Calendar Control

    In old versions of Excel there was an add-in for a DatePicker Calendar Control that allowed dates to be entered into a cell from a monthly calendar. New versions of Excel don't include a DatePicker add-in out of the box, so add-ins have been developed by third parties to fix its absence, and...
  6. C

    How to modify code to update multiple workbook files which has the same format but different data?

    Hello excel programmers. I don't know if you can help me. Yet again, if you are comfortable to view the files below for testing. This is my concerned. I have a code for each of my workbook files below. (I have over 100 workbooks which has the same codes and excel layout, but different data)...
  7. M

    Add in troubles

    Hello, I have a very nasty problem with Excel. Excel adds a path to the function, i.e.: ='C:\Users\Me\Documents\water97_v13.xla'!tSatW(10) But than this gives a #NAME? error. When I manually remove the path, i.e.: =tSatW(10) Than the function works fine. I could manually remove all the...
  8. E

    Help me calculate the formulas for Data Analysis add-in

    Hi Guys, I have a big favour to ask. Within excel there is an add-in called “Data Analysis”, Which can do “Regression” I am able to get the Coefficients using the following formula as an array (if the ranges are set to be the independent and depend variable data)...
  9. glfiedler

    Userform in add-in must be clicked before it is "active"

    I have created an add-in that functions perfectly except for one annoying thing. The add-in creates a new workbook by copying the add-in's first sheet. This new workbook is then populated with data from an archived workbook that the add-in has opened. This works well and I can watch the data...
  10. MrDB4Excel

    Sequence Function

    I am not sure this forum is the right place to ask about this. I use Excel 2013 and have been looking for a downloadable add-in of the sequence function. Is there such an add-in? If so where can it be found?
  11. bfreescott

    Docking Station affecting add-ins?

    Hi all I have a client that uses a network-installed add-in. Several others use the same network-installed add-in without issue, but everyone works from a desktop that never gets disconnected from the network. Could undocking a laptop from the network break the link to the add-in? I have not...
  12. spacecaptainsuperguy

    very hidden sheets add-in

    Hi everyone, I used to have an excel add-in that had a form that allowed me to select multiple sheets from within that spreadsheet and select whether to hide, unhide or make very hidden the selected sheets. I recently upgraded my machine and office and that old add-in no longer works. I've...
  13. A

    VBA - Add In with Modules/Subroutines

    Hello, I am working with different tools based on workbooks at work. Now I don't want to write/update the code, which is over some workbooks the same, again and again in every tool. The solution should be to write this tool, which is exactly the same in every tool, in an add in, and connect...
  14. sparky2205

    Excel Inquire COM Add-in

    Hi folks, I inadvertently removed the Inquire Excel COM Add-in this morning instead of disabling it. Developer Tab > COM Add-ins > Highlight Inquire and press Remove. I'm trying to get it back but nothing seems to work. It no longer appears in the list of COM Add-ins. My ultimate remedy will be...
  15. M

    revision cloud add-in "cloud.xlam"

    I watched a youtube video by Amjad Pervaiz on making rev clouds in Excell. He had a add-in called "cloud.xlam" that would convert a rectangle to a cloud. He could adjust the arc radius, color, and line thickness. Does anyone know where I can get a copy of this add-in?
  16. M

    revison cloud add-in

    I need a copy of the revision cloud add-in named "cloud.xlam".
  17. J

    Trying to make an add-in to copy and paste values for every sheet

    Hi everyone, I need to make an add-in that copies and pastes the values of very sheet in the workbook. I tried running this code and it worked: Sub Saveasvalue() Dim wsh As Worksheet For Each wsh In ThisWorkbook.Worksheets wsh.Cells.Copy wsh.Cells.PasteSpecial...
  18. W

    Cannot run macro from add-in.

    First post to this forum. Familiar enough with computer stuff, but first time user of Excel. I'm doing this to help a friend. Excel 2010 on Windows 7 (Ultimate) running in a VirtualBox VM on Debian Linux Stretch My friend downloaded a free Excel add-in (in an 'xlam' file) which is to file...
  19. L

    Power Query Get Data From SharePoint Folder Pre-2016?

    Hello I've hooked an excel file up to a SharePoint folder on my o365 machine no problem. I'm trying to hook up colleague up as well - she has excel 2013 however and has had to download the Power Query add-in. The add-in doesn't have 'From SharePoint Folder' available under 'From File'...
  20. P

    Check if worksheet exists.... ?

    Trying to put a snip of code at the beginning of an Add-In I've created that will check to make sure the required worksheet exists before it tries to run the code (to avoid error). Below is not working. Any direction/guidance is appreciated. Dim sht As WorksheetDim wb As Workbook If wb Is...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back