users

Hi all, I developed some User Forms base application in VBA excel. My question is not related to code. I am not sure what cause it, but some of end users can see Toolbox, even though then using application and don't even have developer screen opened. Is there any way to disable tool box, so...

Hi, Could anyone assist me. Is it possible to merge multiple rows into one with line breaks. in this cases i need to combine remarks column with using batch name and userid as unique value. Current cases <colgroup><col><col><col></colgroup><tbody> BatchName UserID Remarks Batch1 200123 MK...

Hi, Hopefully someone can please assist. I need to have a spread sheet visible to multiple users at the same time. The Master Copy is the only one that needs to be edited. The other users are purely a Read-Only. Is there a way for the Read-Only to Auto Update, with out the user exiting out and...

I have a tricky question. I have a workbook I am using for a game about 1000 people will be playing. The workbook consists of several sheets but the only sheets users will have access to is a sheet called "Picks". Admin users will have access to all sheets so I already have a system in place...

Greetings Excellers! I'm currently working on a workbook with lots of UDFs and other volatile functions. Trust me, I've done my research and the UDF/volatile function mode is the preferred method in this instance. (The key phrase is "in this instance.") I also have other workbooks where...

I'd created a presentation/tutorial in MS PowerPoint, run it in a terminal mode, where users navigate through vba coded buttons. Now, I'm figuring a way to capture who views the PowerPoint (also, trying to capture their feedback). Could anyone please help with a vba code that could be tied to a...

So I am looking to pick 250 unique winners for a contest. The contest will have 10k-20k unique users. Each user is able to enter multiple times. How do i Pick 10 unique users for 1 prize How do i Pick 240 unqiue users for 2nd prize If your name was picked for any of these prizes it needs to...

So here is what I have...please help I have created three sheets in Excel. The first sheet contains the actual data The second sheet contains an audit log that is already set up through VBA code. The third sheet is a user list of all the authorized users that will be able to access the...

Hello, Is there a formula or code that can be used to auto populate certain texts with certain values? In rows 15 to 26, I am populating column B odd number cells with FROM and even number cells with TO. When users insert rows in this range, I want the FROM and TO to be auto filled instead of...

Hi, I have a shared excel workbook that has a bunch of macros in it. I have it set to open up in read only so users can't modify the information in it but I want to be able to know who has it open. So I was wondering if there is a way to check what users have the file open in read only. Is this...

Hello, In one column (B), users can choose between 'Essential' and 'Desirable'. In another column (C), users can choose between 1 and 5. Do you have a formula for counting the numbers of Essentials in column B and the number of 1s in column C, etc.? It's one formula I need, for doing both...

Hi all! I send workbooks out to users and 1 of the sheets is a library of items that is constantly updated. I have the library sheet on Drop Box and users go there and copy it into their workbook. Is it possible to link the library sheet in users workbooks to the library sheet in Drop Box? Thanks!

Hello, I am using Office 2016 and Windows10. I have 4 files all in a SP doc library - 1 main file with connections to 3 Excel files in the same library. I originally set up the connection using Data > New Query > From File > From (Excel) Workbook. Users had permission errors, I did some...

I have a data set with the persons name in AD and the Date in AE - along with other data I will be pulling. Each date the users will be sending data on what they did that day. So in the data set, column AD will have the user's name listed more than once. As more than one users will be sending...

Hello, I’m making a simple database to store scanned documents for multiple users. I uploaded the documents using the access feature and am able to open the documents in the table. However I can’t open the documents in queries r reports. I wanted users to be able to open the attachments from a...

I make quite a few spreadsheets, intended to be filled out by others. To make them user-friendly (or idiot- proof, as you like…), I like to use data validation for input information, error messages and data limitations. Upon selecting a cell, users are presented with information the content...

When creating a hyperlinks for other users, upon looking further, hovering over the link it shows the directories, the file path of MY computer. i'e. file///C:\Users\User\Documents\Excel\filename.xlsm. No wonder I can't share it. Thanks, ~Jim

So I have a report that uses a Dax formula ( measure) to create a value field that returns the content of the cells. It works great on my computer .. On the other end users get the following message "The query did not run or the Data Model couldn't be accessed. Heres the error message we got...

I created a database and placed it on a shared network where a typical day sees two users entering data into forms that each update the same table. They have both complained of this taking a long time, errors out, and/or get a "database not responding" message. In researching this I thought I...

Hi! New to this forum and to VBA so I'm really hoping we have some experts present :) Let's say I have a list of users and each user has a value for mon-fri. What I want is a listbox with multiselect so I can select multiple users and then the userform should export those usernames J3 and...