locked cells

Hello, I have a simple question but can't figure it out. I have a sheet with locked cells (a template essentially) and I want to be able to paste data into the unlocked cells of this sheet without unprotecting it however Excel won't allow this. Any help is appreciated. Thanks in advance!

Hi! I would like to seek some help on macros unlocking selected locked cells using macro. By default, all cells in my worksheet are protected/locked because, I would like my colleague to use the macro feature of my file. But the problem is, I do not have any background on macros. Can anybody...

Is there a way to lock a cell or group of cells in a worksheet so the cursor does not land on it? I want the cursor to only jump into unlock cells at each entry. Is there a way to do that?

Hi Excel Experts! I wonder if I can have a macro code which will make some contents of my file be accessible (can be modified) to others if only the macro is enabled. I want to lock my file (all cells) to prevent others to change some of its contents. But since Microsoft disables the macro by...

I have a main sheet that references other sheets in my document. I have a refreshable query that changes based on a number i put in. what i would like it to do is from my main table, reference the new data. so for example when i change the "facility" to 126, it reads like this A1 = Dept1...

I need a VBA macro that will unprotect the worksheet with password prompt the user for one field to sort ascending or descending sort the worksheet protect the worksheet with password exit The worksheet has many calculation fields that are locked and not selectable but a locked field may be...

I have a sheet that is protected but does NOT have a password. The sheet contains some columns that are locked and others that are not. I would like to allow users of this sheet to insert new rows into the sheet. My problem is that I want some of the formulas that are locked to be available in...

if i have a sheet with locked cells is there anyway i can see them like the Find command where you can highlight cells which have no formulas or formulas thanks

In my old version of Excel for Mac, the enter and tab keys had the same function with the return key having a separate function. This was extremely useful for entering data into a protected spreadsheet. Each time the enter key was pressed the active cell would move to the next cell SKIPPING...

I have a locked sheet where the value of A1 is tied to a form control. It seems the only way for A1 to update is for A1 to be unlocked. Is there a way to keep A1 locked and still allow it to update depending on whether the control is checked or not? Any help would be greatly appreciated...

Hello all. First off I want to thank the forum--for almost a year now this has been a place I've found a ton of help as a new user. I appreciate all of the work that goes into helping anyone and everyone (beginner, advanced and otherwise). Question I've included an example. my spreadsheet is...

In Sheet1 I have 4 buttons to call the corresponding sub (say page1, page2, page3, page4) that goes to a specific range in Sheet2 (say rng1, rng2, rng3, rng4). I use the following code: Sub page1() Set rng1 = ActiveWorkbook.Worksheets("Sheet2").Range("B1:J20") Application.Goto rng1, True...