users

Hi All, I have a workbook where around 35 macros created to complete and reconcile multiple tasks. Now I want macro can only be run by 3 users like user A & user B & user C. Apart from this nobody can able to run any macros in the workbook. Can anybody suggest me, how to solve this issue...

I'm creating a unique number for new users of a list of 3000. What I would like to do is create random numbers which do not already exist in the list of prior users. Something like: randombetween(100000, 999999) <> A3 Thanks in advance

Hi, All... Background: I have a LAN-based Shared workbook that occasionally becomes corrupted after users go in and change formatting and add highlights. When this happens, I need to do some manual workaround for my VBA to run the next day. The "shared" aspect is mandated by management and I...

Hello and thank you in advance for taking the time to look at this problem. I am needing to build a vehicle delivery sheet that will have around 50 columns and will contain macros. I have done this multiple times and am very happy with how to achieve this but the problem we have is that we need...

I want excel to limit A3:A1003 user to only input numbers 1-1000 for their choices form highest to lowest and if they go out of order to alert next value is the missing number ex: if users input 1,2,3,4,5 and if users accidentally tries to input 7 as next value for excel to prompt message "...

Would anybody know why an excel macro would work for some users but not for others. It works no problem for 95% of users (including myself) but the other 5% get the Run Time Error. To be clear everyone is using the same spreadsheet from the same location. I've stepped into the macro for a...

hello, I have an excel book i created to track inventory. The book has a sheet with a list of users (A), their initials (B) and a password(C). I have placed multiple command buttons on certain sheets that each run a different macro. What i would like is a way for users to be able to log in and...

Hello everyone, I have worked with PowerPivot for my own uses a fair ammount, but recently I was asked to create some reports for other users, and I am getting connection issues that I dont understand when they try to refresh the data source connection. I will put the error message bellow, but...

Hello, I intend to distribute a workbook with custom code, and wanted to control the users of the workbook (to prevent it form being forwarded to others), all of whom use Excel for Mac. I searched and found some software for PC users, but would be grateful if someone had recommendation for...

I have made some macros and added them to a user form. Everything is saved in an Add In file that is deployed to all users. I made a guide how the users can create a Quick Access button, but if I password protect my VBA project the users can’t see the main macro (public) when trying to add it...

Good morning, I am trying to use this reference to create an auto fill data validation. https://www.extendoffice.com/documents/excel/2401-excel-drop-down-list-autocomplete.html?page_comment=1 It works great for a normal named ranged. However, it does not seem to work when I'm trying to...

Is it possible to prevent users from adding the autofilter to Excel?

I've used data validation to only allow users to enter a date within the current month but this still allows users to enter data in other fields. How can I limit users from entering data if the month has passed? Maybe it could be linked to the first cell that has a date A3 (month, year)? Thanks...

Hi, I'm making a "userdatabase". My exceldocumenct contains these sheets: Overview - Will automatically look through User1 to User150 to make some graphs. Users - A list with all users User1 - The database with userinfo User150 - The database with userinfo Template - The database template for...

Not new to Excel but still a novice and I'm not sure how to solve my problem with a spreadsheet I'm working on. If I can solve the problem with the first cell then the others will be easier to correct because they will contain the same function just a different cell reference. So here's my...

Hi, I have a Macro spreadsheet which I am trying to share with other users via OneDrive. Sharing the Spreadsheet is no problem but the other users cannot use my macro to export to OneDrive because they do not have access to the "my" username file path; [CODE]Sheets("Export").Select...

Hi, Due to the way Excel works out dates, 1900 onwards. My worksheet names are numbered for the serial number of the date, on the sheet itself I have an =MID to call the worksheet name, then I convert that in to a readable date in another cell. This is probably a odd way of doing it, but I...

I made a table next to a table of employees. This table has formulas that I would like to preserve (auto-populate) if someone inserts a row. But if I try to insert a row across sheet, it is grayed out. My users do not know excel so trying to tell them to do two different "Insert Into Table" is...

Hey guys. I have a workbook that our users register client details, and create quotations with. We are working to a more productive way of our users working, by offering them a 'fewer clicks' solution to their daily needs of the workbook, and I would like to be able to have the users click a...

Hi All, With some help from you guys on here i have manged to build a small database which i want mutlple users to be able to use. The file itself is on a shared drive where all users have access to be able to see the file in question. The only issue is when they click on it to open it they...