protected cells

Hi I have locked/protected a couple of cells, while simultaneously running some VBA code to hide those cells on a conditional basis. The protected cells cannot be hidden. I have to unprotect the sheet in order to hide the cells. Please help with the same. Also I have a cell B2, who's input...

Hello! I have a model that has two macros in it that both basically copy and paste data. How can I get these to run but also protect the sheets so that no one accidentally makes changes to these (they should be making changes in the master sheets and using the macros to copy the data)... My...

Hi, I'm trying to leave certain cells/functions open for user input, but keep running into a problem I can't figure out. I've been through endless forum threads, but none has been able to help me so far... I have a workbook with 4 sheets, two of which are VeryHidden and not relevant. The third...

Hello, I have a excel file that I have multiple tabs in and I've protected the various tabs by adding a password. My manager had me place the fie on sharepoint so multiple users can access it and make updates. I updated the worksheet to be a "shared worksheet" and now I cannot unlock the...

I have a worksheet with 8 columns for calculating depreciation. The first four columns are user input data including an account number, starting date, cost, and years of asset life. The next four columns would calculate deprecation per year, accumulated depreciation as of the prior fiscal year...

I have a spread sheet that is Locked/Protected. I want to be able to unlock cell D10 based on the Value of cell C10. so if cell C10 ="Other" I want cell D10 to unlock. else then Cell D10 to remain Lock. thank You in advance

Hello everyone I have an Excel (2016) that consists of 5 work sheets. All are protected with specific cells on each sheet being unprotected. I would like to clear all the data in the unprotected cells in 3 of the 5 worksheets proferably by clicking on a CommandButton. I would also like the...

I have workbook with multiple worksheets each having a pivot table and chart. I must have these sheets protected as several people use them to input data. I already have a macro for updating the pivot charts using a refresh button that unprotects the sheet, updates the chart then protects it...

This sheet worked perfect until I hid the menus. It still works if the menus are restored. The only cell on the sheet that is unprotected is the one below store#. When a number is entered the LAN IPs for the various equipment in that store is populated and the equipment that has its box checked...

I have a protected workbook that I cannot allow other users to edit. However, there are several other people who require the information on the spreadsheet, which is why it is protected. Unfortunately, due to Excel failure's apparently, Excel will not allow the users to sort the different...

I have a worksheet that has formulas in row 10. All the formulas except the first one are based on a rolling calendar year (for sick leave), and the first formula is based on a calendar year. One column also has a formula in each cell, but I left it unprotected and used data validation to let...

Hi, I have a template in Excel 2010 which is used by main people to fill in budget for a pitch for a marketing job etc....that has several sections in it for departments and employees hourly cost for a job and then the rows are split into stages. I want to be able to protect hourly rates in...

Hi All I have been trying to protect some important cells, among other things, with my excel today. Having found a fair few posts on here I have managed to protect all of the ones in want. For example columns B, C, D, E, G, H & J, Rows 2 to 20 as some contain data and some formulas. Cloumn F...

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

Hi !!! please help me !!! As starter in web pages design I am searchin how to embed a fully functionaly, protected, not downloable, not copiable, but page visitor user interactive excel file in a web page .... thanks a lot for your valuable help. :confused:

I have a worksheet with a number of hidden and unhidden cells which I need to print. I have a code that works when the sheet is not protected, but I need to modify it to work when the sheet is protected. Any ideas? Sub DSRW1() Rows("66:117").Hidden = False Range("B66:G117").PrintPreview...