Sharing Add-in

May 5, 2009

I am having trouble sharing an Excel Add-in I've created which contains three macros (modules). I have looked everywhere but, oddly, I can't seem to find a definitive answer. I would like for people to be able to install the add-in, and have access to three macros which it contains.

What is the best solution to this problem? I would like to add buttons to the add-in ribbon that execute each macro individually. The macros should be available to all workbooks once the add-in is installed.

View 9 Replies


ADVERTISEMENT

Sharing The Value Of Job Over A Certain Period

Nov 13, 2008

i need to share the valve of the job over the months. see attahed excel sheet. say the job worth 10k has a start date of the 30th of nov and the end date is the 1st of dec. the value of the job is shared between two days and then put into the relevent cell. as regards to the months they are not calander months so the start date and end date of the months are diffrent see attached sheet for full details.

View 2 Replies View Related

Sharing Same Value Between Several Sheets?

May 14, 2013

I have 3 sheets in the same workbook. how could I have all three sheets share the same value if I edit one sheet or the other? Right now I have to edit sheet 2 to get the same value on sheets 1&3. I would like to know how to edit sheet3 to be same as sheet 1&2 vice versa.

View 4 Replies View Related

Limit Use & Sharing

Dec 27, 2007

I've spent a fair amount of time creating a financial planning spreadsheet that I'd like to try to sell. My biggest problem is selling it to people and allowing them to use it without them being able to email it to anyone else. My first thought was to code it where a macro will run when the spreadsheet opens that checks if the spreadsheet is being opened on a specific computer and will close down if it is opened on an unauthorized computer. I'm not sure if this will work or how to code it

View 2 Replies View Related

Tracking Changes Without Sharing The Workbook.

Jun 21, 2006

I have a workbook which has a database and a pivot table. I wish to track changes without sharing the work book.

Is that possible?

Also how can I keep track of the users accessed to the workbook ?

View 3 Replies View Related

Sharing One Workbook With Multiusers

Sep 17, 2006

I build a workbook with 7 users and each user has his own password and this workbook putted in our server drive ( Common Drive ) and each user has the ability to make any thing in his own sheet

So How could make this workbook shared with this 7 users using VBA Code?

View 9 Replies View Related

Sharing Excel File Over Network

Oct 22, 2003

Sharing excel file over network for use by multiple persons. File has suddenly stopped opening giving message "File cannot be found" etc.... I back the file up daily to my hard drive so didn't lose much.

This is the second time this has happened. File size is only 300Kb.

Excel seems to be creating temp files to the same folder, then gave a message saying changes could not be saved to the excel file.

Ran the corruption program from this site, it could not open the file.

View 2 Replies View Related

Sharing Add-in With Password-protected Code?

Apr 10, 2013

I have an add-in which I want to share with others, but I want to protect the code from modification.

I know how to apply a password to a VBA project (Tools -> Project Properties -> Protection) but the problem is this: when a colleague installs the add-in, the subroutines within the add-in are not available in the Macros list to be added to the ribbon (in the Customize Ribbon window). The subroutines only appear when I remove the password.

View 1 Replies View Related

Sharing A Workbook Dependent On Sources

Aug 12, 2007

I have a workbook which relies on another "source" workbook for getting some data. It then does some processing on the data and displays some results.

I want to share the workbook with the results with others, but I don't want to give them the "source" workbook.

View 9 Replies View Related

Sharing Custom Menus & Their Macros

Aug 26, 2008

Our ERP system generates reports in CSV. I have created a custom excel menu, which houses a lot of buttons that launch various macros to format these reports. I have been asked to share these formatting macros with other users.

I understand that the custom menu structures are stored in an excel11.xlb file. My thought was to simply replace the users *.xlb file. This only half worked. I get the menus and the macros, but when the users try to run the macros from the menu excel can't find them because the path is pointing to my user name.

View 3 Replies View Related

Sheets/Worksbooks Online For Sharing

Oct 16, 2006

We want to share an excel sheet online, where we can go to and edit and save it. And possibly link the fields to a dB to build a website from. Anyways what is the best cheapest way of doing this? I googled and found so much stuff, was hoping someone here has already gone thru this process and can just point me to the best one....

View 2 Replies View Related

Run Error 1004 When Sharing Book

Apr 26, 2007

However, since I have shared the document the macros do not work. I am a little confused at this as I thought there would only be a problem if I protected the document, so I took that off yet I get a run error 1004. I have played with the code to have exclusive access but that doesnt appear to make a difference either.

Sub GetDataFromClosedWorkbook()
Dim wb As Workbook
Dim CurrentSheet As String
CurrentSheet = Application.ActiveSheet. Name
' turn off the screen updating
Application. ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
' open the source workbook, read only
Set wb = Workbooks.Open("L:Clearance&AgencyCollateral Management ProductsCMSGRQV SPREADSHEETSRQV.MasterSheet.xls", True, True)...............

View 3 Replies View Related

Sharing Class Module Among Multiple Userforms?

Apr 22, 2014

I have two user forms, each with a checkbox for Jan-Dec. Also, I have a checkbox "All" to check/uncheck the Jan-Dec boxes. I also created a class module so that if any of the Jan-Dec boxes get unchecked, while the "All" box is still checked, it will uncheck the All box. Basically I just don't want the All checkbox to be able to be checked while any single month is unchecked. The only/easiest way I found to do this was with a class module, so I would not need to create individual Checkbox_Jan_Click() events for each month.

Now my issue is, I have 2 userforms like this. I'd like them to share the same class module, but in the class module I need to refer to UserForm1.CheckBox_All. So I need to dynamically refer to whichever userform was active, but as far as I can tell, this is not possible.

View 4 Replies View Related

Sum Of Multiple Ranges Sharing A Single Criteria

Jan 19, 2010

IM trying to add the result of multiple ranges sharing a single criteria and have had no luck. I am trying to get the range from every other colum and have the total qty of the selected criteria display in a single cell. The best way to describe is countif with multiple ranges and a single criteria. perhaps countif isnt the answer, it is the only way i know to describe the issue though.

View 3 Replies View Related

Sharing Workbooks With Macros Built In The File

Jan 15, 2014

Is there a way I can share the workbooks with macros built in the excel file?

View 1 Replies View Related

Sharing Variables In Multiple User Forms

Mar 19, 2007

In VBA i have 3 userforms, the first 2 take the data and store them in variables. The 3rd form is supposed to take the variables from the other two forms and do some calculations with them. Although i cant get the 3rd form to take the stored variables from the other two forms. Is there a way to use stored values from other userforms?

View 3 Replies View Related

Excel 2010 :: Sharing Workbook Corrupts File

Nov 15, 2011

We have an Excel file that 20+ Users update daily. Every time we share the workbook, it corrupts the file within days.

We are using Excel 2010. We go to Review tab, Share Workbook, and check the Allow Changes box.

View 2 Replies View Related

Sharing Workbook With Multiple Users Entering Data Simultaneously

Feb 2, 2013

My Workbook contains several UserForms in which employees will be entering hours and activities on a daily basis. In the UserForm, they select their department and enter hours for each specific type of work/activity that shows up for that department in the userform. They click the submit button and all the data (date, name, department, type of work and hours) is added to a database table in another sheet, which in turn feeds a number of reports.

I need to be able to have anywhere from 20 to 100+ employees enter their hours on a daily basis, many of them at the same time, all from different locations (within the network of the client's system), using the same UserForms.

We've experimented with Google Drive, but that seems not to be the solution. It kind of works, but is not secure (it installs a copy of the entire workbook on the users system and then synchs the data back to the server upon "save") and way too cumbersome. I've heard of SharePoint, but not every client has that installed (and frankly I don't know how it works).

View 3 Replies View Related

Sharing Workbooks; Copy And Paste The Workbook Onto Another Laptop, None Of The Scripts Work

Jan 31, 2007

I have created a workbook with vb code that include 4 modules, 1 userform. These all work in the original workbook. When I copy and paste the workbook onto another laptop, none of the scripts work? Both laptops run the same os plus office 2003.

View 2 Replies View Related

Excel 2010 :: File Sharing - Link 4 Spreadsheets Where Information Will Be Updated By One Person

Apr 21, 2013

I have a Excel Spread Sheet which has been created, there will be 4 people in 4 different locations who will have access to this spreadsheet and will need to update/amend it through "Dropbox", my question/problem is, how can I link the 4 spreadsheets where information will be updated by one person, but will update all 4 sheets at the same time.

Is this possible and how do I go about it?

View 4 Replies View Related

Inventory - Match Part Number To Multiple Vehicles Sharing That Same Number

Jun 3, 2013

I have a spreadsheet listing all my vehicles and their respective oil filter part number. Now, some vehicles share the same oil filter and I am trying to find a way to return the vehicle description when using the filter # as a value. In my example below, I am looking to fill the third column with the Vehicle that also shares the same oil filter number. i.e. in the Dodge row, toyota would appear in the third column and vice versa in the Toyota row.

Vehicle
Oil Filter #
Also used with
Dodge
51515
Honda
54565
Toyota
51515

I am not well versed in excel lingo which is probably why I have a hard time coming up with a method that works.

View 4 Replies View Related

Sharing Workbook And Make Changes On Excel Workbook At Same Time

Jan 23, 2012

Any way that two or more people can share and make changes on a excel workbook at the same time.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved