users

Hi everyone, does anyone have any examples where IF, Ceiling and MAX are used in one formula? I have been asked by one of my users about this. I do not have any data to apply this to, I just wanted to check if it is 'do-able' Many thanks L

Hi i need help. I have create workbook that has a userform. I have users and admin accounts. However with the user accounts they are still able to copy/delete worksheets. Is it possible to make these options only available for my admin accounts? I have looked at protecting the workbooks...

Hey all, I have a workbook which contains multiple sheets for users. And each sheet contains users comments or no comment at all. I want to bring all the comments (if there is any) to a specific sheet. Here is an example file. https://ufile.io/0arac I want comments of all sheets named...

Hi, Hopefully this hasn't been asked before and answered a million times before. And that I explain what I'm looking for well enough. So, i have spreadsheet that I want to share and normally we put this in a shared drive that is accessible from two locations. However when at the third location...

Hi everyone, I'm working on a big project on Excel where I will have about 20 users sharing the same file where they will be filling out a form in which everything gets compiled into 1 data base. The big issue I am having now is if for example 2 users have the same file opened and one submits...

Hello, I am a relatively inexperienced Excel user, but I need to create a workbook that will do something fairly advanced. I will be using Excel 2010 and Windows 7. Goal: I need to track the check-out and check-in of computer laptops by different users with a bar-code scanner. Each user has an...

Hi, is there a way to allow users to operate a data filter when the entire worksheet is protected ? The intended users will not be privy to the password. Kind regards, Chris

G'day, I have a url for API call: eg: http://<api ip="" address="">User=<<IPADDRESS>>:123456&Type=XYZ currently i need to manually change values for those variable to see the status of those users. i get the response in XML. i have 1000 users and Type of users are PrIV or PER. for each of...

I've made an Excel add-in that's supposed to write its own settings folder and file to user's APPDATA folder under Windows 7+. What will be the preferred method to check permissions (folder or user? confused...) :confused: before saving data to that folder? Currently I use a simple line of code...

Hi, Sometimes users report some bugs / errors with screenshots and even identify the line of code that the execution stops at. But the error is not reproduced on our machine. What are the best techniques to reproduce an error? What might be the differences between our machine and user's...

How do I disable alt-f11 to prevent users accessing vba editing

Within an excel workbook I have created a routine that automatically logs the user and date when the workbook is initially opened. The Sub Workbook_Open() calls the routine. For most users it has worked effectively for sometime. However, myself and a few users are now getting the Run-time error...

Dear All, I used Environ "User Name" method in my workbook to assign Visibility of sheets with respect to the users. Now, I dont want any of the users other than in the list to see all the sheets except one or two. Please guide how to do the same. Thank You. Regards Krishnamoorthy S

Hi, I am looking at the following page: https://simeneide.github.io/recommendations/2017/05/27/CFexcel.html and I want to understand how to add more movies and more users to this existing spreadsheet. The goal is to make my own version of this spreadsheet with Microsoft Excel. All suggestions...

Hi Is there a way to close a specific file that may be opened by one or more users on different computers?

Hi everybody! I know that this question has been rarely discussed over the internet and still has no solution. Many users know about really great add-in MOREFUNC with very useful functions. But it works only in 32-bit Excel version. So right now 64-bit version of Morefunc is been looking by...

Good evening, I need some help as I cannot find anything relevant on Google or the forum. Here is my situation: January 1st 2019, I'll open a new business; I plan on signing 5,000 users the 1st month (A2=5,000) have accumulated 500,000 users by end of December 2019 (L2=500,000) reach...

sorry for the poor title, but I can't think of a simple way to describe it here are 3 tables that store the history of every transaction made by every user at automated teller machines (atm) ----------------------------------- table name -- transaction fields transaction id -- primary...