locked

Hi there, I'm trying to put a code into my macro, but I struggle with finding right arguments for the code. I'm want cells from A:F to be locked and be unselectable, and range from H:Q to be locked and selectable. Any ideas? Thanks

Hello :) Im trying to duplicate 2 sheets in a workbook. The idea is to have 1 Sheet that is locked and gets its values from references/links, and the other has macro/button that imports and edits info from another file. In the locked sheet there is Data validation column that must be the only...

I have two workbooks that are a mirror image where workbook A feeds workbook B that part is done, but what I am wondering is if it is possible for the information in workbook B to be locked so in the event the data in workbook A gets deleted it wont be deleted in workbook B?

I'm reluctant to even post this and ask... as its NOT a big deal if I cant figure it out. I can live without having this worksheet protected in the way that I'd like it to be. But, since its kind of an odd-ball request, I'd thought I would post this and ask. By googling and searching this...

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

Hello I am using Excel 2010. I have a worksheet with a pull down list of hospitals. I've locked up all objects and charts on the worksheet but when I select a new hospital, I get a run time error of "method maximumscale of object axes failed". I should point out that I have two sites on one...

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 want to adapt the code below so when the cell has locked after some input the background changes colour The code is Worksheet. Change Private sub worksheet_change(byval target as range) Activesheet.unprotect password:=“blablabla” Target.locked = true Activesheet.protect password :=...

I've created a spreadsheet which has a lot of protected cells, spread all of the sheets. Now that it's finished, I want the cells hidden also (yes I know it would have been easy to do it as I went). Can one of you brainy people please give me a piece of VBA code, that will find, lock and hide...

Workbook is locked to limit anyone changing anything on it or anything else, other than viewing it. But, I do have 4 command buttons onthe worksheet. One is for printing the worksheet, 1 for zooming in, 1 for zooming out, and the last one for resetting the zoom so that it fillsthe screen. With...

Dont know if this is possible, but I thought i would ask... So instead of having to "grab" the scroll bars using the cursor, you could just "grab" anywhere on the sheet and move the sheet up and down. Possible? Here is why I am inquiring: My worksheet/workbook (which is a org char) is...

System.IO.Path.GetInvalidFilenameChars is the list of valid file name chars in vb.Net Is there an equivalent setting in VBA? I can't get into the registry here at work, IT have locked it down to prevent people like me from tinkering :)

Hello Excel Experts, I have a worksheet that is protected by password using VB. The cells in sheets some cells are locked and some are unlocked. This seem to work fine until I close the worksheet. When I reopen the sheet the cells are unlocked automatically but sheet is protected. Thanks in advance.

I have a question that might be rather strange to you. I have made a custom function which accept an input from a cell, and return a result by referencing some data source which will be updated periodically: FUNCTION GiveSthOut(Input as Variant) As Variant <do something="" by=""...

I am attempting to find a way to lock my top row, AND 8 columns on the right side of my page so that they stay locked with the top row. Any ideas on how/if this could be attained?

Re: Locked cells are still editable even though not in "Allow user to edit ranges"-range. I have same issue. I tried many times to Format cells > Protection > Check "Locked" box, but still allow me to edit. I want to ... A) Password protect ranges $A:$I, $O:$P, and $J$1:$N$2 so only I can...

Hi, My worksheet contains data about duration in [h]:mm format. But when the worksheet is opened from another computer the format does not hold. It changes as per the setting of that computer. But at the user's end those cells are locked and they are not able to edit the format. How do I make...

I have a table that I want to stay locked at all times due to other people having access to the table. The other people can edit certain parts but I don’t want them changing the cells with formulas. One of the columns they can edit by entering data will not let them change the color fill of the...

Hi, I have a task to create Excel sheet for team of people with questionable PC skills. For that reason I have created several foolproof safety nets using VBA, but they fail on one thing now. In order to make sure they work, I need make sure that people who use that file have macros enabled...

Having time value problems and it is throwing our time off by 6 minutes or more. Someone posted on a previous thread of mine and asked for the formulas I had. Unfortunately, I got locked out. If you would please reply or anyone reply I would appreciate it. I have the formulas that are coming...