Can I Lock Cells After Input For Certain Users

Jan 5, 2009

I'm using Excel '03 and I need to be able to lock certain cells after input, but only for certain users on my network. Ideally, I (administrator), would still be able to edit the cells in case of a mistake or whatever reason. I want the other users limited to adding information and not editing the existing information in a range. I would need this applied to several columns (B, C, I, and K) if this is possible.

View 9 Replies


ADVERTISEMENT

Protect / Lock Cells After Data Input?

Mar 15, 2013

I have a spreadsheet whee teammates can inut the date in one cell and the exact time in another cell - how do I lock the cell with the time so it can't be changed?

View 1 Replies View Related

Protect/lock Cells After User Input

Jan 9, 2009

Have a worksheet that will be used multiple times. User will enter name and employee number only on the first instance that the worksheet is opened. Would like to protect that info automatically for further usage. Most of the worksheet is protected but some cells need to remain unlocked so the "whole" sheet protection will not work.

How do I protect only specified cells, say F3, G3, H3, I3, after the user enters data thru an input box without changing any other protected cells on the sheet?

View 3 Replies View Related

How To Automatically Lock Cells Every Time Input A Value

May 6, 2004

a code that would automatically lock a cell every time I input a value to it?

View 2 Replies View Related

Lock/unlock Cell Based On Another Cells Input

Feb 25, 2009

I want cell g12 to be locked unless cell h7 is Grass Fire or Timber Fire (H7 is a drop down validated cell)

View 8 Replies View Related

Lock Data Validation List For Certain Users

Feb 26, 2009

i have a query spreadsheet where all business queries are logged. Next to each query you need to select a resolving reason from a drop down list, however i would like some of these to be locked so only certain people could use them.

Lets for ease of use the resolving reasons are the following -

Not paid
Allocated Correctly
Rejected

And say the drop down list is in column P

I would like everyone to use the top 2 but only certain members of the team to be able to use the last one.

I was thinking protect the cells in some way and a worksheet change event of some kind so protect / unprotect depending on the resolving reason.

View 9 Replies View Related

Protect Cells So That Users Can Only Input Numbers Or The Text "NA"

Jun 15, 2006

I need help with a macro that allows users to put only numbers from a range of 0 to 100 and the only text allowed must be "NA" in an Excel sheet. I know that I can protect the cells from being erased and all but my main issue is that my users are putting all kinds of text values instead of NA or numbers above 100 making my life harder than it is.

View 7 Replies View Related

Dynamic Chart On Input By Users

Jun 29, 2006

I am having trouble making a module that can open in all Excel workbooks. It should ask user to enter column names and the data and should ask user to select a chart type and then produce a chart of the entered data?

View 6 Replies View Related

Creating VBA Code That Uses Input From Users To Create A Calendar

Sep 18, 2012

Modify Macro3 and use the InputBox function twice so that Macro3 would ask the user for a particular month and a particular year; and then Macro3 uses these user’s inputs to create the calendar template for that month of the year. For example, if the user enters February for the month and 2012 for the year, Macro3 would create a new

VB:

Sheets("Template").Select
Sheets("Template").Copy After:=Sheets(1)
Sheets("Template (2)").Select
Sheets("Template (2)").Name = "January"

[Code]...

View 1 Replies View Related

Macro To Unhide Columns Based On A Users Input

Apr 2, 2014

I'd like for my spreadsheet to open with only Column A visible; I'd like all other collumns to stay hidden.

I want to create a marco to unhide column(s) based on the value of an individual cell.

For example:

if I enter the number 5 into cell A1, I would like Columns B:F to unhide.
if I enter the number 2 into cell A1, I would like Columns B:C to unhide. Is this possible?

View 10 Replies View Related

How To Lock Down Time And Date When Input Data

May 23, 2012

Is there anyway to lock down the time & date when I input a data? Assuming I have a TIME formula in column A, and a DATE formula in column B. So when I input any data in column C, A & B can automatically show and also lock the time & date.

View 5 Replies View Related

Lock User Input For A Given Amount Of Time

Jan 8, 2008

Is there a way to freeze the user input when it first comes up for a given amount of time. In essence, I am trying to force the user to read before clicking.

View 9 Replies View Related

Linking Cells Globally To Allow Users Ability To Change Cells On Separate Sheet / Cells?

Feb 18, 2014

I have a workbook that uses the values that a user had entered into 3 cells to calculate multiple other charts/diagrams on multiple sheets within the workbook. Each sheet would show what the user had entered in the 3 cells to allow them to see what is being used to calculate each table. Is it possible to link these cells so that the user can change the 3 values without having to go back to where he originally entered the 3 values?

For example, a user has entered in 3 values in Sheet 1. A formula in Sheet 2 displays what is entered by the user and uses these calls in Sheet 2 for calculations. When the user wants to change the three values, he would have to navigate to Sheet 1 and enter in the new values to have the workbook recalculate all the tables. Is there a way to link the three cells from Sheet 1 and Sheet 2 so when the user is on Sheet 2, he has the opportunity to change the values on the current Sheet without having to navigate to Sheet 1 to do so?

View 1 Replies View Related

Input In Multiple Cells To Generate Input Into Single Cell?

Feb 22, 2014

I have a spreadsheet with 5 columns. A1 to A5

Entries are made into columns A2 to A5 but only ever one entry across all cells

If an entry is made into A2 to A5 the I need a "P" to be placed into A1

View 4 Replies View Related

Transferring Of Input From Input Cell To Output Cells?

Jun 8, 2014

I would like to know if it is possible to transfer values of cells this way?

I've attached the excel file for easier reference.

View 3 Replies View Related

How To Make Macro To Lock Certain Cells Connected To Another Cells Value Then Copy Daily

Mar 29, 2014

am making Excel for private use, i need the following makro to be active, here is the idea because i didnt yet work with makros at all:

If A1 = False
then Range B1:D1 will be locked cells

If A1 = True
then Range B1:D1 will be unlocked cells

Those rules apply to 1 day in the year.

the range A1:D1 will be copied about 400 so the makro should be active to each day separatly.

Check the picture attached for example of one day

View 1 Replies View Related

Lock Cells Based On Value Of Other Cells - Code Simplification Query

Apr 22, 2009

I'm using the code below to lock certain cells depending on the value of other cells. The code below deals with one line of my spreadsheet only and as the spreadsheet comprises 38 data entry rows I've repeated this code 38 times in the worksheet module with the appropriate changes to row numbers.

It works, but causes much screen flickering and "thinking". I'm new to vba so no doubt I've made this code too extensive or lengthy or whatever (or just plain wrong).

Can anyone assist with suggestions on how to simplify the code and/or help with code to handle all 38 lines without repeating the routine 38 times?

View 7 Replies View Related

Lock Empty Cells In Range Based On Other Cells Content

Apr 18, 2008

I am trying to lock the unused cells in 32, 2 column by 7 row named ranges, based on whether or not two cells, above each range are equal or less than each other. In other words while one of the cells is less than or equal to the second cell all cells in the range below should be unlocked, as soon as that condition is no longer true the blank cells need to be locked.

I am trying to use this in the Workbook_Sheetcalculate so that the macro will run automatically.

View 3 Replies View Related

Restrict Users To Only Editting Certain Cells?

Apr 6, 2009

I need a way to protect my worksheet from any changes but allowing the users to edit certain cells (eg. allowing users to enter data only into columns A-G).

View 2 Replies View Related

Prevent Users *Selecting* Cells Using VB

Jun 2, 2006

I am currently setting up protection on an excel sheet - I have a proceedure to open a specific worsheet and lock and unlock cells according to whether or not certain information exisit. My question is, although I can lock cells and prevent users changing them using code I can't seem to stop them selecting cells in the first place - this is obviously achieveable from the 'Protection'>'protect workbook' menu but I want to do it from code since the sheet is unprotected and reprotected a number of times during a session....

View 4 Replies View Related

Lock Certain Cells By Vba

Nov 7, 2006

I am aware of setting protection to certain cells by the Excel Options. which is unlocking the by defalut locked cells and then setting the sheet protect in tools->protection. I want this to be done through VBA code.

i have a template which has text in some cells and some cells are blank, i need to lock the cells which has text and keep the blank cells unlocked for user input. As this is a template it will be copied to another sheet, so i need to retain the protection properties in all new sheets (copied from the template). Attaching the template for which the protection needs to be done.As of now the sheet1 has protection property set through the toolbar properties.

View 2 Replies View Related

Lock Cells After Done With Formula?

Feb 8, 2014

I use the attached workbook to keep tack of feed use in turkeys. when a new flock is added to a farm (Airport View or Home farm) A template is copied and pasted from the "templates" sheet depending on what type of diet they will be on. (Ralco ABF or Ralco Standard) that template refers to the Ration sheet to calculate how much corn is in each diet. After a flock is complete I will never change the numbers again, it is just for record keeping. I want to be able to change the Corn/ton numbers in a ration (on the rations tab) if need be and not affect all the older completed records.

View 1 Replies View Related

Lock Dragging Of Cells

Oct 22, 2008

Is there a way to protect a sheet from a user dragging a cell?

View 6 Replies View Related

Lock Cells When Saving?

Aug 1, 2014

I have used the following code to lock cells when saving.

I need to exclude Cell B2 when saving

let me know what changes i should make.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
if ActiveSheet.Name = "Summary" Then
On Error Resume Next
'Resume to next line if any error occurs
Dim Cell As Range
With ActiveSheet
'first of all unprotect the entire
'sheet and unlock all cells
.Unprotect Password:="pw"

[code]....

View 2 Replies View Related

Lock Cells On Condition

May 1, 2009

W3:W300 is a protected range containing formulas returning numbers from one upwards, with two decimal places.

I need some vba to check this range and, if a number greater than 1 is found, to make the corresponding cells in Columns X and Y blank and lock them.

View 9 Replies View Related

Lock Cells Upon Selection

Jun 20, 2006

I am assigned to a very tedious task which requires me to lock selectively, cells from Jan through to Dec. Instead clicking the cells and selecting the various options from the menu bar, I would like to do it the other way.

If I want to go locking a cell upon selecting it, what are the VB codings?

View 9 Replies View Related

Lock Cells Over Four Worksheets In One Go

Mar 12, 2007

I am trying to get user to enter month and goto sheet named the month they enter. I would also like to tag on the end of each one a 1,2,3,4 as I have four sheets four each month. Jan1, Jan2, Jan3, Jan4 etc..

Sub Cell()
Dim InptPass As String
Dim Pass As String
Dim month As String
Pass = "mypassword"
InptPass = InputBox("Please Enter Password")
If InptPass <> Pass Then
MsgBox "Incorrect Password", vbCritical
Exit Sub
Else
month = InputBox("Enter Month to Lock")
month1.Activate
ActiveSheet.Range("A1:BK22").Locked = True
MsgBox "Cells Locked", vbInformation
End If
End Sub

View 4 Replies View Related

Lock Cells For A Certain Time After Entry

Oct 10, 2012

I've got a spreadsheet set up for a simple barcode scanning system. The user scans the barcode of the product when complete, and it logs it to a sheet along with a date & time timestamp. I'm then planning to use a v-lookup (barcode to product name) & pivot-table to count instances of 'product name' so that I can monitor what is being produced easier, nothing too tricky.

The problem I'm having comes from the products of the same spec having the same barcode, so data validation is hard to apply, as I can't 'not allow dupes' - the concern I have is that if the user unknowingly (or knowingly!) scans the same ticket twice, I think I've got 2 of a product when I've only got one. The idea I had was to lock all cells for a set time period (say 1 minute) after an entry so that it couldn't be accidentally scanned twice.

View 1 Replies View Related

Lock Column Cells In Table

Mar 27, 2014

I want to copy a formula and want to lock a certain column, just like you use the dollar signs in normal formulas. Because the data in tables can't be locked with dollar signs.

Example:

example 1.xlsx

View 2 Replies View Related

Lock Cells Together And Rank Rows

Sep 8, 2009

Basically I have recently started my own personal music chart and I'm having problems with a Year To Date page.

Basically all I want to know how to do is how to lock some cells together and rank many rows of those cells with 1 column where the total is?

I have attached the spreadsheet as a zip files as I was having problems uploading it as a xls file.

View 13 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved