lock

Hi All I am recording a macro to lock a sheet with a password but when I run the macro, it locks the sheet but does not use a password to protect it. Is it possible to use a macro to lock a sheet with a password? Thank you Happy New Year!

I have a worksheet with a multipage object. On each page I have a series of frames, and within those frames a series of checkboxes. Is there a way that I can set the lock properties for all the checkboxes of all the pages without having to set each one on their own? Each of the pages has 50 or...

Hello all, looking for a way to lock a select number of cells, regardless of what rows are added above it. am working with a table, and will always be adding rows at the top of the table (so all data shifts down a row). the data that i want to lock in place is actually outside of the table...

Dear Sir, I am using following code to refresh my pivot table which is on same sheet as of data The sheet is protected as well since I dont want user to change the format but it is not working on lock sheet, in unlock sheet, its working fine. Sub Pivot() ' ' Pivot Macro ' '...

I have Excel Office 365. My question: how do I prevent scroll lock from "auto-disabling" after I save? Here's what happens: (1) I have scroll lock enabled on a spreadsheet, (2) I enter any new information on the sheet, (3) I click control + S to save my work, and (4) scroll lock automatically...

Hi! Is there a way to leave some cells editable, but then lock the entire worksheet at once. I can only seem to do this a sheet at a time (Protect Sheet). I tried Protect Workbook, but this didn't lock the cells. Given my file has a lot of sheets, I have my fingers crossed that there is an...

I want formula to lock a row or column except today's date with password protection. Example In A column I have dates and i have numbers in b column If a person click on yesterday date row or future date row or column the user could not be modified the data in B Row or column For any...

Hi, I am currently using this code assigned to a button which locks my sheet so no one can edit in a workbook but now i would like this code to only lock a particular cell which contains a list dropdown or range for eg. Cell C4 or C4:H4 Can someone please help me on this. Ive tried a lot but to...

Hello Excel/VBA Masters! I got a table and with info that needs to be verified by employee. Next to each row of information there is Data Validation list (Verified / Not Verified). I got formulas down that show the username and time+date of verification, than i i lock the cells if there is any...

I need a macro that will unlock (an already locked cell) when selected and then lock back when deselected. Is this possible? Thanks in advance!!!

is it possible to do a V lock up with out create a new colon with the function left? <colgroup><col width="87" style="width: 65pt;"><col width="91" style="width: 68pt;"><col width="87" span="3" style="width: 65pt;"></colgroup><tbody> code amount code amount 209 -cost of...

Hi all. I am struggling to find a way to lock the position of multiple slicers, yet allow them to still work. I have a report to send to players and the worksheets will be protected. When I do this the slicer is not usable but other methods mean that it can be moved and deleted by the end user...

Hi I send out a report once a month to about 50 different people so they can fill it in and return it to me. I recently tried locking ranges of the report to try and reduce the amount of errors I was seeing in their submissions. However I just got a report sent back with a complaint that they...

So I found lots of references to this kinda code for locking all sheets at once. Sub ProtectAll() Dim wSheet As Worksheet Dim Pwd As String Pwd = InputBox("Enter your password to protect all worksheets", "Password Input") For Each wSheet In Worksheets wSheet.Protect...

I have an Excel spreadsheet with 90 cells that that are unlocked when I protect the sheet I'm looking to write a macro that will do the following when I run it: 1. Lock the sheet so only unlocked cells are able to be selected 2. Lock the cells B9:J9, B15:J15, B21:J21, B33:J33 and B39:J39 3. Lock...

Hello everyone, I'm struggling to get this code right. Hopefully someone here can steer me in the right direction and help me out. <tbody> LOCK PERSON DATE CONTROL no Value 1 Value 2 Person 1 01-01-2018 1234 15 55 Person 2 20-02-2018 5678 20 42 Person 3 15-04-2018 9012 34 37 </tbody>...

i googled some vba code for what i want to do. but in trying to put a few commands together. what i want to do doesnt work. i have a 5 column worksheet, one page worth. 1- i want to lock column C when data is entered. i also want to ask a question whether the data is okay before locking. 2- when...

Hey everyone, I have a sheet that is protected that we use internally to calculate funds for customers. The sheet itself undergoes some changes for each customer, including deleting rows; I have tried macros to just protect as data is entered or on save, but there are too many variables that I...

Title basically says it all, I have a user created form I'm trying to lock a formula in to automatically update something to a yes or no, but sometimes users may need to change it manually to yes or no thus why I have a drop down there. Any ideas/suggestions or is this just not possible currently?

Hi I use this formula below, but my issue I am having is I use this in my macro I run which shifts the sheet called Pay!. What happens the $AY below in red changes to like Z Or anything Less then AY. Is there a way to lock the AY cell so it wont change at all? Even with $AY it changes so wanted...