edited

Hi Guys. Is there a possibility in excel to lock the filters? Meaning that I do set up some filters for certain columns and I want prevent other file users to modify it ? Note - I do not want to lock cells to be edited, just filters. Or maybe is there a simple clever macro that would show a...

Good day. I'm running Excel 2016 on Windows 10 Pro. I have a workbook hat contains 8 worksheets with 17 Macros. I intend to make this workbook available to other Excel users who wish to track the data that my workbook will track. Each user will have the ability to have tracked items changed...

Hi everyone, Recently I had this issue whereby an excel file is being shared between multiple users but only the first-to-open the file can do edits. So whenever the user edited and close the file, data from row 38 would disappear. The next user inputs the data and the new data will be filled...

My Data <colgroup><col><col><col><col><col></colgroup><tbody> 1 A B C D 2 Sequence Date/Time Who What 3 1 10/1/18 2:41 PM John Smith Open* 4 1 10/1/18 2:41 PM John Smith Edited 5 2 10/4/18 2:15 PM John Smith Open* 6 2 10/4/18 2:15 PM John Smith Edited 7 3 10/5/18 2:16 PM John...

I have a workbook with 11 sheets. Sheet 6 contains a lot of information that is sent to payroll on a regular basis that contains details of extra hours worked for a lot of workers and so is updated frequently. The sheet is protected so that users can only edit columns F and H across to V as the...

Lads, I have formula applied to entire column e.g. =A1+B1. When I change formula in one cell I need and hit enter this new formula automatically applies to the rest of column. Then I hit backspace and formulas on rest of column goes back to normal and my just edited cell has got the new formula...

how can we highlight last edited cell e.g if i use A1 it will highlight after use and then i use B5 then highlighting remove from A1 and B5 will highlight

Wondering if anyone has ever experienced something where you've edited code and debugging over and over, discovering your edited code isn't included in the execution; instead, a previous interpretation of written code is being executed from memory (doesn't contain the alterations you've just...

Hi, Would anyone have VBA Code to lock a Workbook with 50+ tabs 1. Workbook can only be edited if correct password entered 2. If the person does not have the password then the Workbook is Read-Only Thanks

Hello there! Spreadsheet example: <colgroup><col><col span="11"></colgroup><tbody> Mario Speedwagon. 3 6 0 4 7 5 25 5 8 8 6 Petey Cruiser. 3 3 8 8 6 8 5 38 8 8 8 </tbody> I've been wondering if it's possible to do this: When I click on a name, the other cells in the same row that I could...