password cell

Hi Everyone, I am trying to do something on a workbook but could really do with some help please! First Part - I have a tab on a workbook that has a macro and data validation, the macro and validation relate only to rows "A" to "U", the idea is that a person comes into the tab and fills in the...

Hello everybody, I am currently managing an order form in Excel, where people download it and then they go in every day, fill out the details and submit the order through a macro. They will just need to download it once and then do this whenever they have an order. However, is there any way in...

We have a spreadsheet which has ranges that are password protected (i.e. using AllowEditRanges with a password). This is not because we don't want users to be allowed to ever change those cells, but rather it is to prevent them from changing them accidentally. Users are provided with the...

So I am trying to password protect my workbook so that it won't open unless you have the password. But here's what i need: I need to have a cell that contains the password so that it can be changed whenever and easily for someone who has no excel or computer literacy, without going through...

Hi, I have a few sheets in a workbook, which have macro`s, formula`s. When someone wants to input information they can do in the main sheets, where there are no formula`s, only input information. How can I lock or password protect the sheet or stop keying in the sheet, protecting the cells...

Hi! I have a cell (J2) and I only want people with a password to be able to unhide and edit this cell. I can't seem to figure out a way without having to "protect", "unprotect" (to make edits) and "re-protect" again. Does anyone have any recommendations or advice on how to best achieve this...

So, I'm trying to create a random 15 digit password with certain criteria. At least 3 of the following; uppercase, lowercase, special characters, numbers. I also want to make each character unique, I have 2 formulas: 1...

Is it possible to protect different columns with different passwords in the same Sheet? I am trying to protect different columns with different passwords so different users can only write in their own column? Many thanks

<HR style="BACKGROUND-COLOR: #ffffff; COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message --> I have one problem . pl. help me to solve my problem. In ecxel worksheet When I enter any data in one cell I want to auto lock the cell after the data fill. ( after leave the cell) Suppose...