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
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.
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.
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.
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?
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.
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.
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.
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....
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)...............
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.
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.
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?
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).
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.
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.
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.
I copied the macro and it works on text files, but will this work if you have a .csv file or does it have to be text? What I have is an extra large .csv file that needs to be broken up into a couple of sheets.
I am running a formula on a large data set and need the returned value to never be less than zero or more than 100. using the MIN and MAX functions, but how do I use them both at the same time?
I'm adding some necessary code to the beginning and end of some cell contents in Format | Cells | Custom and I seem to be coming up against a character limit.
I'm using the phrase "!!<"@">!!" to add the code, but with some cell contents the result is ########### (but much longer), and I'm having to remove some of the text to make it work. The limit seems to be around 255 characters.
I have a formula that adds two numbers. Here it is:
=IF(E10="","",(E10+$C$8))
I don't want the numbers to be more than 360 when added up. When it reaches 360, I want it to start over from zero. Instead of, say, E10 = 200 and C8 = 200 ... I don't want the answer to be 400, I want it to be 40.
I have a workbook with 3 sheets. Sheet 1 contains a month of data with Customer Name and Product Code, and quantity shipped (columns A, B, and C). Sheet 2 contains Product Code and quantity produced (Column A and B). In Sheet 3, I have the customer name listed once by running a pivot table against the data in Sheet 1. I need to show the quantity produced for each customer in Sheet 3 but not exceed the quantity produced for that Product Code in Sheet 2 even if the quantity shipped was greater. For example:
Sheet 1 Customer A - 100 shipped of Product Code X Customer B - 200 shipped of Product Code X
Sheet 2 Product Code X - 150 produced
Sheet 3 Customer A - 100 total Customer B - 50 total
Customer B would only be allocated 50 as there was only 150 produced and Customer A was allocated 100 of the total 150 produced, leaving 50 to allocate to Customer B.
how to make a summation formula in excel (not simply adding 2 numbers together)? I have one cell that I would enter a number into, and another cell which would specify the limit. So if the first cell A1 = 1, and cell A2 = 50, then the 3rd cell would automatically add up every number "n" plus 1 until n=50. ie: (1+1)+(2+1)+(3+1)+...+(50+1)=result. The limit would have to be flexible, so if I change the 3rd cell to 70 then it would calculate to 70.
