locked

  1. C

    Macropod

    you locked my original thread didnt know how else to get a hold of you
  2. S

    Sheet Protection

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

    Sheet duplication, VBA help.

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

    Linking workbooks and locking cells

    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?
  5. K

    need cells so that they are NOT protected in named ranges, but everywhere else locked...

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

    Locking all sheets with macro........works, but first sheet different than rest.

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

    Lock Charts But Still Allow them To Work When Filter Changes?

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

    Protect entire workbook - including unprotected cells

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

    Auto Format locked cells

    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 :=...
  10. Y

    How to hide cells that are already locked with VBA

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

    I have a workbook that is locked except for everything except viewing.. how do i allow for printing though?

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

    is there such a thing where VBA or script could allow you to maneuver worksheet similar to how you would navigate on google maps

    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...
  13. Johnny C

    Excel VBA equivalent to System.IO.Path.GetInvalidFilenameChars

    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 :)
  14. A

    Locked cells are unlocked when I reopen worksheet

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

    Make a custom UDF intentionally not to refresh

    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=""...
  16. D

    Locking Columns/Rows Together?

    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?
  17. F

    Re: Locked cells are still editable even though not in "Allow user to edit ranges"-range.

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

    Stopping automatic data format change in other computers

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

    Editing a protected spreadsheet

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

    Locking/unlocking cells using VBA while starting and closing workbook

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

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