protected

Hi Everyone, I have a data input form in Column B to J starting at row 12 the page is protected and I want to unlock the protected rows as data gets added to the row above. it would be best to trigger it from column B So it would go: on selection if cell is in column B the unlock the row...

I have an Index|Match formula that references a password protected sheet. I am finding if I make a correction in the referenced sheet, it is not getting updated in my original sheet that contains my lookup formula. Any ideas? Thanks!

This might be a silly question, but is there a way to delete a row in a protected sheet for someone who is using the sheet without the password? I can't find anything online. Any help would be appreciated.

Hi All, I am looking to create my own macro from an external report that I receive. The external report is write protected so the first step that im getting the macro to do is copy the cells into a new workbook. my code is: Range("A1").CurrentRegion.Copy Selection.Copy...

Hi all. Can I exclude chart from being locked in a protected sheet? i use dropdown to get chart to compare data. i want chart to be active inside a protected sheet. Is it possible? if yes, how can i do it? (i'm using excel 2007) Thanks

I am trying to make wholesale changes to a sheet but Can't Find & Replace As Error Comes Up Saying Protected Sheet. It is not protected as it is a brand new worksheet. I think it may have to do with wanting to change commas for / etc. Any way around this please?

Hey, I have a macro that does things to xls files that are found in a long list of hyperlinks. Some of these hyperlinks cannot be opened because they are protected. Is there a way to unprotect and reprotect any protected files? This is the relevant part of the code: CodeNames = Range("Z2:Z" &...

Hi guys, I'm currently in the process of creating a training matrix. I designed the layout thinking I wouldn't need to go the lengths of protecting certain areas of the work sheets, but a colleague of mine has proven me wrong. I protected the sheets not realising it would stop the groups...

Hi and thanks in advance Is it possible to know if a Excel file is password protected without opening the file ? I have the following code: Sub PasswordProtected() On Error Resume Next: Application.ScreenUpdating = False Dim rWorkBook As Range: Set rWorkBook =...

My workbook, one of the sheet is protected and having all graph and a pivot table. Other sheets are not protected , but I am getting error while opening due to protection in that one sheet . It is trying to refresh while opening. Can someone help me having a VBA code to solve this when opening...

Hi I have a sheet for Work In Progress stocktaking. The sheet is protected except for cells in which order number are typed. Using ENTER or TAB brings you down to the next cell for typing, in between typing cells are 10 rows with lots of lookup (Index,Match). Problem is reaching bottom row on...

Have any of you come across a password breaker that can unlock single sheets in a workbook? I have a large workbook from a previous project, several years ago that I have password protected. There are over 150 sheets in the workbook, each sheet is protected individually. I have run the common...

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.

I have three sheets that are protected and all have grouped areas. I need my users to be able to use these features while the sheet is protected. I found this VBA code online and turned the workbook from .xlsx to .xlsm. Works perfect for sheet 1, how to i add in the ability for sheet 2 and 3. I...