locks

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

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?

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.

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

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

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