1. D

    VBA to add list of users to SharePoint site

    Hi, I am looking to add a list of users from excel onto a SharePoint site and grant them permissions in a specific group. My excel consists of the following information: GroupName UserAccountEmail It will just be users uploaded to one specific SharePoint site. Any assistance is...
  2. J

    Macro to keep track of username and time for users who opens an excel file

    Dear Team, I have got a macro in an excel file which tracks the username and time of the users opening the file which I definitely need. The problem is that if 1 user opens the file and leaves it open then it doesn't track the name/time of other users who open the file when its in use. Is it...
  3. D

    Right Click Sheet Tab

    Hi, how can I hide the 'right click' options on a Worksheet Tab (not the Worksheet Cells) pls... I have a Worksheet that I lock with VBA (password) and I dont want users to be able to unlock hte Sheet through the 'right click' option, eg: Insert / Delete / Rename, etc
  4. S

    split costs by overlap range dates

    Hello I have a list of costs to be divided for a list of users. Is it possible to allocate the costs, which the date range concerning, to users on the days of use? NB if in one day more users use the same service / cost, the cost must be divided by the number of users <html><head><title>Excel...
  5. gheyman

    Access: Keep Navigation pane closed

    Is there a way to keep the navigation pane closed or keep users from accessing it without proper permissions?
  6. D

    SQLITE Integration

    Hello everyone, Can you please tell me the best practice for importing SQLITE data into Excel? I want to create a pivot table for several users to access. I tried the get data from other source but doesn't seem to work
  7. A

    Best formula to count login - logout time

    Hey Dear community, i have big list of users login and logout time, i need to count users work time, i use minifs and maxifs to find login and logout time minifs-maxifs=result , is there any other ( easy ) way to do this? Names are in D:D and times are in J:J
  8. N

    VBA Code to fill group of data

    Hello, I have a userform "PC" to manage the PCs usage and timing I have 8 PCs in each room, sometimes each one (or some of them) used for different type/time... and sometimes all of them for the same type/time... In the userform "PC" I have the following controls 1- Combo Box "cmb_Num" (List...
  9. B

    Keeping ADO connection open at all times

    Hi, I have an application built from an excel userform where users connect to an access database to pull and write data. However, now we have a decent amount of users using this program I want to keep track who is in the program. The best way I could think of was to create a second database...
  10. G

    Not allow users to hide columns in protected sheet

    Hi all, I have a protected sheet, where I want the users to be able to change the size of the columns but not to hide them. In the option "Protect sheet" I can unable "Format columns", but If I do that, the users will not be able to change the size of the columns. Is there a code for this...
  11. W

    How to show different userform based on users screen resolution?

    I have a userform that is to large on screens that are 1920*1080 or below, how can I check users resolution and if it is smaller or 1920*1080 I want to display the small userform? If it is 1920*1080 or bigger I want to display the normal userform?
  12. J

    =UNIQUE coming to O365?

    Hi all Does anyone have an ideas of when the new array formulas are coming to excel O365? They were released to insiders exactly one year ago now but still no sign for normal users. Apologies if there is already a thread on this, I I did a quick search but couldn't find Thanks Joe
  13. S

    Amend existing macro to select a different address string if first string could not be found

    Hi, I have a macro which is used by different users, has been working for years with no issues but now, due to an IT change, different users have been given different network addresses which I can't get to be changed so all have the same path. In order for the code to run for all users, One...
  14. D

    Getting External Data From Access

    I created a split DB that is used throughout our small office. A couple of my coworkers need to move some of data to Excel from the tables in the back end that is housed on a shared volume inside of our LAN. First I setup the connections Using the basic "From Access" wizard, but that tool...
  15. A

    Having trouble making diagram

    Hello all, so I want to make a diagram, but would like it to be like spiderweb or something. It is interconnecting and comparing diagram. so example A1 b1 c1 d1 e1 1 7 4 5 2 2 8 10 11 3 3 3 A1 d1 4 6 B1 5 9 6 4...
  16. C

    Registration form - Ideas

    Hi.. I am looking for suggestion / guidance on the best approach. I have a user form that users can register for classes. They select they name and class they want. They can also go in and delete entry later if they decide not to take class. This works great. I want to make some enhancements...
  17. U


    Hello, Would you know when would all Excel, Office 365 users will be able to utilize the following formula: "XLOOKUP"
  18. D

    Identify unique values

    Hi Excel gurus, Could someone please help me. I have a report with users group assignment in the system. Users are assigned to read-only and full access groups. Email address is the unique field in the report. I wanted to apply a formula under User ID's so we we can identify and filter if...
  19. J

    Create hyperlinks to files in folder

    Hi Can anyone help with a VBA code that makes a Hyperlink to cells? This Workbook is a staff list where in column "E" it is possible to use a Hyperlink next to each person to see a photo The path to the file is e.g. C: \Users \ Division \ Staff \ 38543_Benny_Mcgee \...
  20. JackDanIce

    Pivot table auto refresh, live dashboard update

    Hi, I have a data table turned into a pivot table. I want to use this pivot table to drive a dashboard (i.e. slicers, timelines other interaction) A user needs to be able to change variables which updates data table which in turn updates pivot table and dashboardE.g. a variable that affects a...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back