locks

  1. M

    Protected workbook - Lock More Cells

    Hi, I have a workbook which has a number of projected cells by default. I want to create a VBA that will enable me to press a button that locks certain additional cels, is this possible? Thanks, Matt
  2. synergy16

    form locking out other sheets

    good morning all. im having an issue that when a user opens a form taht i made based on VBA code, it locks them out from access to any other non-related excel sheets. is there a fix for this?
  3. Fluff

    Fonts changing & page locking

    Is anybody else having problems with the board today? I'm regularly finding that the font has changed & when that happens the page locks & you either have to refresh, or go back.
  4. R

    My question is about Highline Excel 2016 Class 06

    My question is about putting locks on data in a formula. for example =SUMIFS(COGS,Region,$J20,SalesRep,K$19,Product,$K$18) Why are locks only put on the column in J20 and not the row and why are locks only put on the row in K19 and why are both locks put on K18? This can be seen around the...
  5. D

    Looking up a value based on row and column

    I am currently working on a big project, and need to fill in the pricing schedule. In table 1, I would like an easy way to fill in the question marks. I have over 150 "cars" to fill in, so I am looking for the best solution to get this automated. I am used to work with Vlookup, but I have over...
  6. BrianMH

    Calling ADO Experts (any MVPs about?) - Issues with disconnections

    Hi everyone, I don't use ADO much but I've inherited something that is using ADO and I've had a few problems. Our network infrastructure isn't the greatest here and some times the connection to our shared drives momentarily drops. It doesn't unmap the drives or anything but we get an error in...

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