users

  1. 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
  2. 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...
  3. 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?
  4. 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
  5. 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
  6. 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...
  7. 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...
  8. 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...
  9. 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?
  10. 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
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. U

    Xlookup

    Hello, Would you know when would all Excel, Office 365 users will be able to utilize the following formula: "XLOOKUP"
  16. 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...
  17. 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 \...
  18. J

    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...
  19. skorpionkz

    [VBA] Toolbox show up for end user

    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...
  20. S

    Combine multiple row into one with line breaks using sql

    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...

Some videos you may like

This Week's Hot Topics

Top