Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop Formula input
Hello,
I was wondering if anyone could help me. I'm trying to restrict formulas being inputted into cells so that figures are inputted manually. This is because the numbers can change due to links being broken or cells being moved around on a worksheet. Can anybody help? Thanks, B |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop Formula input
Hi,
You could do this. Right click the sheet tab, view code and paste this in:- Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String = "A1:b20" '<== change to suit On Error GoTo ws_exit Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then If Target.HasFormula Then Target.Value = "" MsgBox "Formula not allowed" End If End If ws_exit: Application.EnableEvents = True End Sub Mike "Gruff" wrote: Hello, I was wondering if anyone could help me. I'm trying to restrict formulas being inputted into cells so that figures are inputted manually. This is because the numbers can change due to links being broken or cells being moved around on a worksheet. Can anybody help? Thanks, B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Input date & Time [NOW()], then stop it updating? | Excel Worksheet Functions | |||
How do I stop the input cell from jumping to the mouse cursor? | Excel Discussion (Misc queries) | |||
Excel writes "May 10" when I input "5-10". How to stop this? | Excel Discussion (Misc queries) | |||
input box = formula bar | Excel Discussion (Misc queries) | |||
how do i get excel to stop changing my input 5-9 to 9-May???? | Excel Discussion (Misc queries) |