how to restrict to not to edit an individual cell in google spread sheet after entering a value

Question

0.00/5 (No votes)

See more:

Hello Experts,

How should i restrict an individual cell to be edited in a spread sheet after entering a value using macros.

i.e., An individual cell in the google spread sheet should accept a value only for one time.

Posted 1-Sep-13 23:39pm

Harsha24

Updated 3-Sep-13 22:20pm

v4

Add a Solution

Comments

Bala Selvanayagam 2-Sep-13 5:42am

You mean locking an EXCEL spread sheet cell using JavaScript ?

As far as i know, you can not use JavaScript to manage EXCEL. You may have to look into some EXCEL VBA/MAcros, if am not mistaken

Harsha24 2-Sep-13 5:45am

yup.. thanks for the info.. could u pls help me on this..

Bala Selvanayagam 2-Sep-13 5:54am

Have a look at

http://www.mrexcel.com/forum/excel-questions/213186-lock-cell-macro.html

Also, you can google on this and you will have many suggestions/ solutions

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raja Sekhar S · Answer 1 · 2013-09-02T01:22:00

u Can try some thing like this...

VB

Public RunWhen As Double
 Const cRunIntervalSeconds = 60    'Specify the seconds after which the macro has to run...
 Const cRunWhat = "LockCell"
 
 Private Sub Workbook_open()
    StartTimer
 End Sub

Sub StartTimer()
    RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds)
    Application.OnTime EarliestTime:=RunWhen, Procedure:=cRunWhat, Schedule:=True
End Sub

Sub LockCell()
    Sheets("Sheetname").Range("A1").Locked = True
    'MsgBox "Process Completed"
    StartTimer
End Sub

in the above one am running the lockcell macro after every 60 seconds...