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
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
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
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
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...
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...
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...
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?
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
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,
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...
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.
A1 b1 c1 d1 e1
1 7 4 5 2
2 8 10 11 3
3 3 A1 d1
4 6 B1
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...
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...
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 \...
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...
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.