Search results

Another option would be to do it in VBA. Right click on the sheet tab and copy/paste the following. Option Explicit Const TARGETRANGE = "$A$1:$A$10" ' Range with ID's (try named range instead) Private Sub Worksheet_Change(ByVal Target As Range) Dim regex As Object Dim...

If you right-click on the Sheet1 tab, click View Code and copy/paste the following: Sub Test() Application.MacroOptions Macro:="Sheet1.Test", ShortcutKey:="s" ActiveWindow.DisplayWorkbookTabs = False End Sub Sub UndoTest() Application.MacroOptions Macro:="Sheet1.Test&#34...

The formula is probably now referencing different cells that no longer give a valid answer. I see in the formula you reference Master!C13 without it being an absolute reference (no dollar signs), which means it's now probably pointing somewhere else.

I have a better understanding now. Right-click on the sheet tab and copy/paste the following: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Range("E12"), Target) Is Nothing Then If Not IsEmpty(Target.Value) Then Me.Protect End If End If End Sub As soon...

If you have excel 2007 or 2010 there is a button on the ribbon to do just that. Check on the Data tab.

So you want to be able to manually adjust after you've done the initial setting with the Shift code. Here's some VBA to try. Right click on the sheet tab and copy/paste this code. Option Explicit Const TRAPCELLS = "B2:B6" Const LOOKUPCELLS = "B11:B14" Const SHIFTCOLUMNS = 10...

I know you said you'd prefer not to use formulas because you'd have to fill the entire range, it's actually pretty easy. If you use the right formula you won't have to change it for each cell in the range C2:L6...

I'm having trouble understanding it too, but I'm going to guess this: 1) You have a range of cells in Sheet1 that require data entry 2) All cells (at least cells requiring data entry) should be unlocked initially 3) Only after the LAST cell of data is entered should the sheet be locked You...

Luke, I think you meant to 'dim' those variables as x, y, and z in firstfunction() too didn't you?