I have written a VBA code.
I thought I could just save it as an ADD-IN and then have my colleagues to add it, but that does not work. The macro will be stored in a seperate workbook and that is not what I want. I want them to be able to open any workbook and want them to be able to run the macro. I.e. everytime they open a workbook the macro should be available and be ready to run.
I have a large worksheet that for some reason I can’t share.
-It does not have any lists, that I know of, do not know how to see if there are any
-It does have validation, but I have other workbooks with listed validation that are shareable
-It is not protected
-Does not have any named ranges
-Is not read only
-I have saved it as another file name and no luck there
-I have copied the one sheet I really need into a separate file to try that it did not work,
I'm trying to convert various codes from one column of an excel spreadsheet into different codes in another column. I was able to accomplish this with "If" statements, however I'm only able to string together seven of these statements in one command. Is there a better way to add formulas for more than seven conversions? Below is a copy of what I've done so far with the seven converts:
=IF(ISNUMBER(SEARCH("WARN",J2)),"Warning",IF(ISNUMBER(SEARCH("PSSNAP",N2)),"Sales",IF(ISNUMBER(SEARCH("WARN",L2)),"Warning",IF(ISNUMBER(SEARCH("2699",L2)),"Warning",IF(ISNUMBER(SEARCH("4004",L2)),"Warning",IF(ISNUMBER(SEARCH("2036",L2)),"Warning",""))))))
I want to add about 15 more codes to convert within this formula but it's maxed out in the format I'm using.
I need to know that how can we share excel workbook. Is it possible over LAN? Also how many users can access the shared workbook. If 50 users are accessing shared workbook and each one working on different workbook. Is this scenario feasible? Will there be any issue if 50 users working on 50 different worksheets of same workbook?
View 2 Replies View RelatedMy company has a lot of file excel. I usually use Google driver, LAN and a lot of the other ways to share file to all member in the company. But so, it is time consuming very much and not protect information in my execl file.
View 5 Replies View RelatedI have a workbook full of tables and pivot tables. When I try to share it tells me to convert the tables to ranges or to something about XML.
View 6 Replies View RelatedWe have a spreadsheet at work that is saved as Micosoft.xlsx [share].
I think the "[share]" means that more than one person can access it at the same time. How do you create a document like this.
How do I share a macro(s) to other users so they can use it? Each user has different location because we are working remotely.
View 1 Replies View RelatedNeed code to disable and enable "Protect and Share Workbook"?
View 9 Replies View RelatedI have the following code, and it is working well for one file. I'm trying to figure out how to do a loop to go through each region folder and update, save, and close each file just like the code below is doing for one file.
There are 10 region folders
Each region folder contains 8 or fewer files.
Please see the sample code below for the sample file location.
Sub TrendByRegion()
Application.EnableCancelKey = xlDisabled
Set wbOpen = Workbooks.Open(Filename:= _
"S:High Level ShareReportsReports by RegionPivot Table Files
Region 1Catalog File.xls")
wbOpen.RefreshAll
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub
I have a workbook which is used by over 100 people. It is turned on to share mode, but to ensure it would stay like that I need the workbook to check whether it is shared while being opened and then turn to share mode in case this would not be the fact.
View 4 Replies View RelatedI have an excel document that I wish to share for multiple users to edit, but get the following error message Excel tabs or XML maps.
View 3 Replies View RelatedMy coworkers and I use a couple of Excel documents to store statistics. The document is on a network share. We all have Office 2010, my coworkers are on Windows XP, I am on Windows 7.
If I open the document and make changes, then save it to the network location I can open the document later and see the changes but my coworkers do not see any changes I have made. Also If my coworkers make changes to the document the 3 of them see the changes but I do not.
If I go straight to the network share the timestamp on the document only changes for changes I made.For example if I go to servernamefoldernamestats.xls and add data to the file. Then save and close it. I can reopen the file and my changes are there.
Tomorrow Coworker 2 opens the same file from the same location but it has data from 2 days ago, with a timestamp of 2 days ago and my data is missing. They then reimput the data I entered, and add todays data. Then they save it and close.I open the file it has my data from yesterday, but not the new data entered by coworker 2.
I have created some macros that need to be used in several workbooks by more than one users, so I put them in an add-in and gave them instructions on how to get the add-in. I also created a toolbar with buttons calling those macros, attached it to a workbook the users can open, and instructed them to open that workbook once to get the toolbar.
Both the add-in and the toolbar workbook are on a network drive that my users can access, but when they get the add-in, it gets copied to their own add-in folder.
Here's my problem:
When a user tries to click on one of the buttons in the toolbar, the button tries to call the macro using the path that would be valid on my computer to get to my add-in folder. This path includes my user name, so it doesn't go to their own add-in folder: it goes to my add-in folder on that computer if I ever logged in on that particular machine, or it goes nowhere.
When I created the button, I attached the macros by referring to the add-in workbook by name only, without referring to a path, so I don't know why MY path ended up defined on that toolbar.
How can I go around this? I manually relinked all the buttons for that user, and I can do it for the other users (there aren't that many users nor that many buttons), but I'd rather avoid it: I'll have to re-do it if the toolbar is updated and it just seems like more work than should be necessary.
I'm also opened to suggestions on a better way to share those macros. They can't be attached to the workbooks because we use new workbooks every year - they're emailed to us by the people who create them and for a variety of reasons, pasting everything into a workbook of our own is not a good option.
I have a workbook, that has a lot of VBA code, & Userforms. I need to be able to share the workbook with a number of users.
View 13 Replies View RelatedI currently have a macro that can be used by multiple spreadsheets. Is there that I can execute the macro within any specific spreadsheet without saving it in each spreadsheet. I just want to place it in a general spot so that in case there is modifications, I only have to change it in one place.
View 14 Replies View Relatedcombining 2 rows that share 1 cell so that it is easier to format cells. For example: A4 and A5 have been combined with B4 and B5 to form 1 cell that has content. How can I convert this to a cell that only occupies A4?
View 1 Replies View RelatedI need to read an excel file on share point. The file name is like 'file_name.Vx.x.xls'
Where x.x is an incremental and can change. How can I retrive the correct name?
Is there a way that I can share a worksheet that I am working on so people can view it in order to have feedback?
View 9 Replies View RelatedI have access to a huge database in excel that involves sales data. The database is catagorized like:
Column A = Country
Column B = Product
Column C = Company
Column D = (Product) category
Column E = Sales
Column F = Period
Column G = Sales of particular company
Column H = Market category
Further details: see attached file!
I am looking for way to express developments ( absolute and relative) in market growth and market share over time.
I have 3 questions:
How can i show the growth of the total market sales over time (period 1 to 4)?
How can i show the growth of the Int comapny sales over time (period 1 to 4)?
How can i show the market share of the Int company over time (period 1 to 4)?
Market growth can be calculated by comparing the sales amounts of the total market (or the Int company) to previous periods. Market share can be calculated by expressing the sales figures of the Int company in percentage of the total sales in a partical period (i=1,2,3,4).
I created a macro in VBA that pops up a calendar with keyboard short cut and places the date in selected cell. It works great on my pc. I can't share the macro with anyone. I saved it as an add-in...installing the add-in did nothing. Then I saved it as a template...the template did not open with any macros associated. both cases, no errors. no message to enable to disable macro.
View 4 Replies View RelatedI have a speadsheet, and at the moment, another spreadsheet access it via a vb code. but i have 3 - 5 agents needing it sometimes at the same time. All that happens, is the agents excel sheet passes some info to the server sheet, so the vb codes opens and closes it. So only one person can do it at the same time.. but i need this so anyone of the agents can enter info via the vb code.
When i tested it, it asked me when i opened it, if i wanted to save what the last person did, I need that not to come up, so really its like the sheet is always open, but not... and lines are added. The info is added to the same sheet, and line by line.
I am wondering how I can highlight rows that contain the same text across selected columns (not all). For example, consider the following table:
ID#6527
Jay
yellow
dog
[Code]...
I want to focus on Columns B, C, and D. I would like rows 3 and 5 to be highlighted, since they share the same text across the target columns. I assume this can be done via a formula in Conditional Formatting, but I'm not sure.
Right now I have a script that will highlight any rows where columns "Unit1" and "Unit2" share the same value.
The script is below:
[Code] .....
How to modify this so that it only highlights rows where the same data is duplicated twice?
For example if both columns had "The dog runs" as their value in the same row, then this would only get highlighted if two or more rows on the sheet also had "The dog runs" for both their value.
Example: example.jpg
I have a workbook that I would like to share and allow multiple users to add and make changes at the same time. However, the workbook is full of macros that really need to run. Is this possible? The workbook is written in excel 2003.
If this is not possible then is it possible to share the workbook in a similar fashion but not allow any other users to make changes, but update their workbook with the changes that I make?
I have a workbook which contains multiple worksheets of employees' information. I'm hoping to share this workbook out. Each employee only able to view and update their own worksheet and their manager, being able to view/update everything within the workbook.
Is there anywhere I can set up a Online Excel Spreadsheet to share with a few friends with a password option to prevent people from looking at it?
I need everyone in the group to be able to update and save the spreadsheet
I created two pivots:
1 provides sales data for companies in a time period,
2 provides market share data for companies in a time period.
Both pivots can be filter by page fields country and category. Now i want to calculate 4 average market share values (because i have 4 defined periods): 1 average MS in period 1, 1 average MS in period 2, etc. In this average i want to exclude companies that are not active in a certain period (pivot table shows MS = "0%") and companies that totally not active in all periods (pivot table doesn't shows market share data at all after a certain selection of the page fields).
Attachment : calculate averages from pivot table.zip
I created two pivots: 1 provides sales data for companies in a time period, 2 provides market share data for companies in a time period. Both pivots can be filter by page fields country and category. Now i want to calculate 4 average market share values (because i have 4 defined periods): 1 average MS in period 1, 1 average MS in period 2, etc. In this average i want to exclude companies that are not active in a certain period (pivot table shows MS = "0%") and companies that totally not active in all periods (pivot table doesn't shows market share data at all after a certain selection of the page fields). Check out my attachment too to symplify this question. How how i formulate this formula?
View 4 Replies View RelatedIs it possible to use the userform when it is protected and shared.
I am able to access when it is protected. but unable to access when that protected worksheet is shared.runtime error message " unprotect method sheet class failed" appears it is shared and used.I have already raised this [b]issue in the forum.I understood from the answers that it is not possible.
" My requirement is multiple users should use the form and they should not have the access to edit the entires made by them"
Please give me a solution.
" Being a moderator myself i should only be able to edit or modify the entries made by the users."
Note:
I dont want to create multiple excel sheets for multiple users.i want to use a single excel sheet (Shared and protected)
Also provide me an alterante solutions if any