lock

I've created a button that saves as the workbook with a custom name with the word "report". It' Puts the words "Locked Report" on every sheet. Problem is, it's not locked. Part of my functionality of this workbook is I have control buttons create customized entry fields. Some cells are protected...

Hi, I'm trying to lock down a cell if the value in another cell equals a certain value. I have the following code but get the error "Run-time error '1004': Unable to set the Lock property of the Range class" Private Sub Worksheet_Change(ByVal Target As Range) If Range("F4") = "Lock" Then...

Please help! I have a workbook that has 30 tabs all are the same. I have added a button to protect each sheet and another to unprotect. This is so that when the sheet is full it is locked off so nobody can change the info. My problem is when I share it! I cannot use the buttons. Is there another...

Is there a way to lock down an excel spreadsheet so that users cannot make changes to the formulas? :) Users will be entered data in the cells on tab1 and the formulas are listed on tab2

Hello friends, i need your help, i have searched all topics and could not still get to solution First of all i want to mention that problem happens with me on all excels later then 2003 on all PCs . now the problem: when you insert autoshape via macro or via INSERT Tab (any size any shape)...

What code can I use to lock A2 only if A3=1?

Good Day I recently upgraded two user to Win 10 and Office 2016 but they cannot open an excel protected password while other user can open it with the very same password. Any help please. Error: "The password you supplied is incorrect.Verify the CAPS LOCK key is off..."

HI Can you help me please i have the code below, but it doesnt seem to work, i think i am putting the code in the wrong place i added this to a new module but it doesnt work, i only want to lock cells in sheets(Northants) and the cells i want to lock are B8, B9, B10, B11, F8 and F9, can you help...

Good day all, I am working a project that allows multiple people to contribute to a worksheet. So that people do not edit information after someone has completed a section of the form, I would like to lock parts of the worksheet. Ideally I want a command button on the worksheet that locks a...

Hi, I use workbook with 62 sheets (number of shifts in month). On every sheet are lock and also unlock cells, sheet is protected by password, so users are allow edit only unlock cells. I try to find easiest way to lock remainig unlock cells (for example some macro by clicking on button). Than...

Hi, I have a worksheet that I purposely protect and allow users to edit numerous unlocked cells within the protected sheet. However, I would like the user to be able to lock his/her own cells also. Within the protected worksheet they have access to unlocked cells. Is there a way without them...

Here is my code to lock the scroll area and it does work but how can I get this to run without having to use a button to start the code. Sub SetAllScrollAreas() 'Update 20140326 Dim ws As Worksheet For Each ws In Application.ActiveWorkbook.Worksheets ws.ScrollArea = ws.UsedRange.Address...

Hi, I am currently running a sheet where I copy an image into a cell in column 'R', now there can be 1 picture or they could be 10 pictures in that 1 cell. But this sheet is filtered and so I need to lock the picture to the cell so that they stick with the same row and keep the sheet tidy. Is...

Hi All! New here! Been reading this forum for some very helpful tips and solutions but 1st time to register as I cant seem to find a solution to what I need to do. Could you give me a marco command to lock cells that contains specific texts (e.g. cells containing "new report", or "Completed"...

I want to lock a cell which has date in row column, it should be not editable on the row, if the date is in past date and only the present date & Future date row should be editable. If the A1 row date 07-Mar-2018 - the entire row should not be eidtable and it should editable with a password...

I have spent the last hour looking at different forums looking for a solution to my issue. I have a... "Product Family Slicer" with 5 VALUE STREAMS to choose from in the slicer. However, each time you select a specific Product Family, the cursor jumps halfway across the spreadsheet and lands...

Curious if this is possible: If you have a form that shows the fields for a records from a table, can you add a checkbox, either as part of the fields or separate, that when checked keeps the user from changing the data? I'm not necessarily wanting to "Lock" it as I am trying to keep it from...

Hello, I am using excel 2010 and I can't scroll up or down while I'm in the formula bar to edit the cell, but I can move horizontally. My colleagues are using the same excel and they can scroll either way. I searched the internet for over a week and came up with no solution. To narrow down...

Hi, First let me thank you for taking the time to read this thread. I am very new in excel, I have 3 cells (A1, A2, A3) and I would like to know if it is possible to lock one out of the three when two have data. for example; If I have A1="any number" and A3="any number" I want A2 to be...

Hi Is it possible to lock Tabs on a Spreadsheet book? The spreadsheet has 20 Tabs. It there a way to lock 3 specific Tabs [all tabs have a specific name] so these cannot be edited unless you have the password to unlock. What is the best way to lock the 3 Tabs? Can these 3 be protected with a...