multiple users

Is there a way to put a workbook onto a website that will be able to use macros and have users only access to enter numerical values into specified cells? Have been looking through the web for this solution. I want it so that on this website my workbook is as if I sent a protected macro workbook...

Hi All, Ive searched and searched and cant find an answer to my query. If it has been answered already please point me in the right direction. I have a shared excel workbook where multiple staff could be in at the same time. Staff input and update data via a userform. To populate the excel...

Hi, I did some searching but did not find what I was looking for. Sorry if this has already been answered. I want to make a log in excel that will auto-fill certain areas. The only problem is legally it needs to have restricted access/ the ability to prove they modified the log. The perfect...

Hey all, I have tried searching for the answer for this problem and I can not seem to find the answer that I need, so was hoping that you guys could help. I have created a workbook that we use within my work that shows what every member of staff is working for any given hour they are at work...

Hi I am sitting whit a problem I can't solved right now. I am working on a sheet where we are more users. I wanted to make a button to make the sheet to a pdf a save it on how ever use the spreadsheet desktop. I don't seem to find a solution on the internet and therefor ask here. Right now...

Hello, A project I'm working on has a button that is supposed to create a static, macro free copy of the workbook and save it to the folder which is located on OneDrive. This button will be used by multiple users, not just me. I have this coded and it works perfectly whenever I test it, but...

Hello All! I have a macro that sorts a raw data set and adds a bunch of buttons. Those buttons call methods that search for a specific data set, sort data, or build graphs. It all works great when used on a single computer, but I'm having trouble if the document is emailed. If I run the macro...

The idea is a visiting person(s) wanting to come to visit site submits details 48hours previous for security to approve. At present our office uploads the data to a security form and emails to security via one of our managers to approve. The workbook takes out the repartition and has saved an...

Hi folks, The issue I am having is I have tens of thousands of entries in an excel workbook and all of them require different users to put a comment for the ones belong to them. Since there may be up to 100 users accessing the file at the same time, the file has been constantly corrupting. I...

Hi Is it possible to create a message alert that would inform all users working on a shared spreadsheet that (Username) has opened / closed said workbook? Regards Paul

Hi, Can you please tell me if i want to embed my online excel workbook in a restricted webpage (clients can access after username and password) 1. Does my workbook can give access to multiple users at the same time such that one user who is currently editing a workbook doesnot create problems...

So little background, I have an excel userform that my end users interact with. This form pulls and pushes data to and from Access databases. The trouble I am running into is that when I have several users on and they are pulling records at the same time, often they will pull matching records...

Hi All, Thanks in advance for any help you can provide. I have quite a large spreadsheet. I want to set up an auto email reminder (using outlook) so I can go back and check on the status of certain files I keep track of. I have a userform that fills out certain information and on this I have...

Is it possible to create a excel sheet and then send it via email in such a way that allows multiple users to access it, but updates to every sheet? I am not sure if that is clear. But I want to have multiple people be able to open the sheet on different computers/locations/times and be able to...

Hello everyone, I need help with a new feature for a Excel based program I'm working on. I currently have a macro that searches a list object table for words that match a target string and returns information that target string based off of which will matched in the table. The database table...

Is there a way to save macros in an add-in or something so that I can save a macro-enabled workbook to a share drive for people to access and use? Right now the document I created only works for people who have newer computers. For everyone else I have to sit at their desk and save the doc as a...

I am working on an Excel project that I am trying to make interactive with a group of 30 people. I originally tried doing this on Google Sheets, but that doesn't have specific locking features or the ability to create macros so I have to do it on excel. The problem I am encountering is that I...

Good day, For our next project we would like to use a master excel file (monitoring dashboard) that brings together all the information stored in 4 individual excel files in a cloud. The 4 individual excel users should not see the master file (as they should not see each others work) but I...

Dear All, From the web link : https://support.office.com/en-nz/article/Use-a-shared-workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61 I have understood that the SHARED WORKBOOK feature in Excel, allows multiple user to read and write on a single EXCEL Workbook kept on a common...

My entire Finance Department wants to show negative numbers with parentheses -- as (1), not as -1. I created a custom format that does this for me, and which aligns the decimal points. When other people in my department open a file that I created, they see the negative number as I want them to...