sheet protection

Hey guys, I want to protect my sheet in a way that once an entry is made into a cell, it's not editable anymore without admin password Here's a link to the sheet I want to word on. https://1drv.ms/x/s!Arx4wtU9Crs1mGu2gr1cMQ1Hfm6t

Hi Everyone. I need some help again. I have a sheet for a health check history report on a machine. This is completed on a monthly basis to get some trends on the machine. Some of the inputs are then used to calculate the expected life of the machine to predict when components are to be...

We are currently using Excel 2007, The spreadsheet has a lot of different calculators involved and would like to protect the sheet and have only certain cells accessible. I created a form control drop down box that lists about 30 different vendors, the users would click on the drop down to...

Good Afternoon, BLUF: Is it possible to add new cells to a sheets' "protection/lock" without supplying the original password?... I was tasked with making a "logbook" document that would act much like pen and paper. I've gotten a macro to add a new line to the top of the worksheet (keeping the...

I have a worksheet with multiple drop down lists that allow for multiple selections. The sheet loses this functionality when I protect the sheet. I need to keep the sheet protection as the document is going to be utilized by many people. I don't want them all making changes. How can I fix...

I have a program that depends on VBA and cell formulas that I send to customers for projections. We do not want them to have access to either the formulas or the VBA. I feel the VBA is safe (enough) with password protection. However, even with sheet protection, one of our customers sent back a...

Can anybody tell me how to protect two columns in my Excel Table that contain formulas? I created a table, highlighted the range of cells that I want to unlock, then protect the sheet. I also check that I want to allow users to add rows to my worksheet. As soon as I protect the sheet, the...

Hello Excel Experts, 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...

Dear all, This is my code in order to protect some rows and columns of my sheet. Sheets("Purchasing Plan").Select ActiveSheet.Unprotect "PJMS" Cells.Select Selection.EntireColumn.Hidden = False Selection.EntireRow.Hidden = False On Error Resume Next ActiveSheet.ShowAllData On Error...

Hi all, I am wondering if there is a way to transfer the sheet protection from one worksheet to another worksheet via VBA. Currently, the user selects a name from a drop down list, it unhides a workbook of the same name, copies from that workbook, and places the copied information in an...