edited

  1. L

    Lock filters

    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...
  2. Dan Wilson

    Macro editing

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

    Data Disappearing from a specific row

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

    CountIfs how to

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

    code to lock only certain rows when criteria is met

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

    Single cell formula changes after reopening spreadsheet.

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

    highlighting last edited cell

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

    Excel macro executing memorixed code; not including the edits I just added

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

    VBA for Protecting Workbook

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

    Highlight other cells when I select another

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

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top