protection

I am trying to fix a timestamp issue as most have asked about in this forum; however, my question is a little different from the 75+ that have been previously asked. I have a userform that loops through and adds rows of data to a worksheet (SurvData). In worksheet SurvData, I have a cell that...

Good afternoon, I'll come clean - I'm trying to work out a formula for item enchantment in Minecraft. I'm trying to find a formula to indicate whether it's more cost-effective at purchasing two items that are enchanted at a particular level over one item that is enchanted at the next level up...

Hi, i have been trying to get the following to run, but keeps erroring, effectively if value in range (x,25) is contained in Range "i;I") i want "NA Protection" in (X,18), othereise blank FinalRow = Cells(Rows.Count, 1).End(xlUp).Row For x = 2 To FinalRow cells(X,18)= If...

I don't know if at all the following would be possible and if so what the best solution might be. For the weekly competition in our bridgeclub an Excel workbook/sheet is being used. The workbook is protected (not with a password, i.e. it is easy to unprotect it) Someone adds the results to the...

I have a fillFormula macro, but I want to include something in it to 1) apply a conditional formatting to Range("C7:C" & Lr) that will look for duplicate values and apply a red-bold format to each, and 2) to set column C to a text format so that it will stop dropping leading zeros. Also, I...

I have a worksheet that i surmise has some sort of protection. I can't highlight a column to insert a new column. The cursor appears as a double-headed arrow when i hover over column. How can i check the different protections on this worksheet? Thanks.

Good day. I have some excel project and is circulated in a group of people. Some sheets contain complicated formula so I protected the sheet and allow them to just view for their reference. My concern is that some have removed the protection ..... Please advise on how to fully protect sheets...

Hi folks, I wonder if anyone knows a way to determine if a worksheet is protected WITH a password vs. protected without a password. I know how to check for protection in general...but not how to figure out if there's a password attached to that protection. Any insight/direction is greatly...

Hi Everyone, I was wondering if there was a macro that I could run to remove all page protection and another to add it to all sheets? they all have the same password "Superman1" thanks Tony

Morning All, I would like to protect a workbook using VB, so that I can add the protection to the end of an update macro I have created I would like to lock certain columns so they can't be edited at all, some that the user can do what they want with, and others that they can only input data...

In excel 2007 I could prevent users from unfreezing panes by protecting the workbook and checking the window protection, is there a workaround to achieve this again in these versions of excel where the window protection is greyed out?

Dear Friends I have a workbook with two worksheets Sheet 1 and Sheet2 Now in sheet 1 I want user to be able to select ONLY cell A1 and B1. Rest of the cells in the sheet 1 should be restricted. Also cell A1 of Sheet 1 contains a hyperlink to cell A2 of Sheet 2 and cell B1 of sheet contains a...

I am building a tool where users can create sheets for their individual projects that will later be used to automatically generate powerpoint slides. Everything worked great until I tried to add sheet protection to limit their editing to only the input cells required... Here is the template...

Hi In view of the imminent changes to Data Protection in the EU, we are having to be much more careful about how we share data with each other. I am using Excel spreadsheets and have just created, saved and password protected an Excel spreadsheet to send to my client. Separately I texted him the...

I'm thinking of setting below protection for my Excel file so only designated users could open and use it. The concept is that I'll put a list of Windows user name in the file (in a hidden sheet) which lists out who can open the file. Then when the file is being opened, it will lookup the...

I am working on a spreadsheet to track maintenance, it needs to be protected so that none of the formulas or formats are messed up by the users. Anyway I have this piece of Code that changes the sheet based on a a choice earlier on, and it runs perfectly when the sheet is protected or not...

Hi all, As you may all know, setting DisplayAlerts=FALSE doesn't prevent the warning message from poping up when attempting to edit/modify a protected worksheet. The only two hacks that I know of are either using a Windows Timer or installing a CBT Windows hook that monitors the application...

Hello, I have a template worksheet in which most cells are marked as "Locked" for protection (under format) while specific cells are left unlocked. Now I want to copy this specific arrangement of locked/unlocked cells (not the cell contents, just the protection status) onto many other sheets...

One of the features I love about Excel tables is that as you complete a row of data and tab through, it will automatically expand to start the next row. Further, that doing this carries forward formulas and formatting to the newly added row. However, I am finding that if the sheet with the...

Hello, I have a sheet which has a column that contains cells which are drop-down lists with the same three choices for all of them. I was wondering if there was any way for me to protect the drop-down list cells in order to enforce a unique selection; that means, once an option from the...