Window 7下載 for mac vmware fusion windows 10. In Excel VBA, is there a way to select specific locked cells, while leaving other cells 'unselectable'? I have an excel sheet, which is protected. I would like to give the user the ability to select specific locked cells within a sheet while at the same time not allowing them to select other locked cells within the same sheet. Basically I have a small, cell-based calendar, in which I would like them to be able to select specific dates (locked cells) on this small range, however there is no need for them to select any other locked cells within the sheet.

Excels Sheet Protection only seems to allow a sheet-wide 'Select Lock Cells'. If there is a way to accomplish this through VBA I would love to hear about it. I did look over a lot of other posts before posting here.

When you protect a worksheet, the behaviour in each cell is defined by the Locked property. Sample code: ActiveSheet.Unprotect ActiveSheet.Range('A1').Locked = False ActiveSheet.Range('A2').Locked = True ActiveSheet.Protect ActiveSheet.EnableSelection = xlNoRestrictions 'All the cells can be selected With this code, users can edit cell A1 but not cell A2. Bear in mind that, by default, the Locked property is set to True. CLARIFICATION Protection is applied to the whole worksheet. At the cell level, all what you can do is relying on the Locked property.

What you cannot get is different behaviours for different (Locked/Unlocked) ranges. Hello, Thanks for your prompt reply. My apologies for my confusing question. I understand the locked feature, however my issue is i need them all locked, however just a subset of those locked cells i want the user to be able to select, while the other set of locked cells i dont want them to select. Excel provides a 'Select Locked Cells' option when protecting a worksheet, however it is sheet-wide, without the ability to specify a range of locked cells to select, while another range, not to select.

Select the cell that you want to lock or hold down Ctrl to select multiple cells, right click on one of the selected cell and select 'Format Cells' Go to 'Protection' Tab and check 'Locked', Press OK Go to 'Review' Tab and click on 'Protect Sheet', enter password, re enter password, press OK.

Any thoughts? – Oct 20 '13 at 15:50 •.

While using a Macbook for a period of time in 2013, I realised that there are some differences when using Mac Office and Windows Office. One example is if I wanted to lock a cell, say for example A1. I would put the dollar sign ($) in from of both the column and row number as follows: $A$1. This still works in the Mac world if I enter it manually, but in the Windows version of Excel, there was a keyboard shortcut (highlight A1 in the formula bar and then press the F4 button) which would put the $ signs in for you. This method is, by far, very much less tedious than typing the dollar sign each time and moving the mouse to precisely the right location.