saving a user for as a add in

Scott M

Board Regular
Joined
Dec 31, 2011
Messages
152
Is there a way to save a user form as a add in I think that I saw this before but cant seem to locate it.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,785
Office Version
  1. 2010
Platform
  1. Windows
You can save a workbook containing a form as an add-in. It's an option in the Save dialog.
 

Scott M

Board Regular
Joined
Dec 31, 2011
Messages
152
Thanks I will give that a try but I was hoping to just save the form only. So that the user could click on the name or icon and bring up the form any where they are working i.e.. any workbook that is open. Without having to open another workbook
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,785
Office Version
  1. 2010
Platform
  1. Windows
That won't work. A form is part of a workbook.
 

Scott M

Board Regular
Joined
Dec 31, 2011
Messages
152
I made a Vba user form I created a button In my home tab that would run a macro to show the user form using the Custom UI Editor that I downloaded from Here Change the Ribbon in Excel 2007 or Excel 2010 I followed the instructions and every thing works fine. I then saved the workbook as a Add in and loaded it.Closed the workbook. The button is in my home tab but when I click on it I get this error "Wrong number of arguments or invalid property assignment "If I open the workbook manually then I see two buttons and when I click on either one then the form will show. What I am trying to achieve is to be able to put this add in on mutable computers at work that would allow the users to run this form without having to open the workbook manually i.e. click the button in the ribbon and run the form. Thanks for any help
 

Watch MrExcel Video

Forum statistics

Threads
1,130,117
Messages
5,640,208
Members
417,131
Latest member
Seanr19871

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 MrExcel.com.
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 "mrexcel.com".
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
Top