• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lock today's cell (row/column)

DineshK

New Member
Hi.
I really appreciate if someone can help me in executing macros as mention.
I try to many site to excute my query but fail to do so. I also execute above code but fail to use. So i again write in this forum so that
My team need to data entry on daily basis on today's date. All cells should be locked only today's will be open for data entry/editable. Also it should be protected too.


61536



I really appreciate if someone help me.
Thanks
 
OK.
Need all cells to be closed only we can edit data / input values in under today's date column only. Also if this can be highlighted so that resource immediately recognize where they have to enter data.
Sample sheet attached.
 

Attachments

  • All cells locked.xlsx
    33 KB · Views: 10
Great! it works fine. Really thanks
But could you please Editable Columns A,B,C and Rows 1,2,3 so that i can modify as per our need.
 
Last edited:
DineshK
If it works fine ... hmm?
... why 'BUT'-sentence?
Didn't You hoped:
All cells should be locked only today's will be open for data entry/editable.
Need all cells to be closed only we can edit data / input values in under today's date column only.
Also if this can be highlighted so that resource immediately recognize where they have to enter data.

Or what would those three sentences mean?
 
Good Morning,
BUT - I didn't mean its just flow of words. The forum help me lot previously.
Thank you very much for the code. I really mean it.
 
Last edited:
DineshK
Do You know how much extra work would mean Your 'its just flow of words'?
Many times 'its just flow of words' would mean that everything should do again from zero!
Of course, Your 'its just flow of words' would mean for You ... eg just use new file ... but for others ... hmm?
I can put this waiting for next possible time,
after I would get and idea,
what to change,
without doing everything from zero.
 
DineshK
After You have had time to think ...
and You've read my previous reply about 42minutes ago ...
Your the latest 'flow of words' still means that ...
You would ...
1) only add dates to right, because ... You know!
2) edit also A ..C-columns
... interesting?
 
Sorry for late reply. Yes flow of words still means
Column- A to C -> Editable
Rows- 1 to 3 -> Editable (row 3 for dates which can be editable on monthly basis)
Hope this time words are correct :)
 
DineshK
Seems that You have focused my #1 ... one second!
Could You sit down and ... think ... or something
If You edit any date eg 1-Jul to 1-Aug ...
what can You do after that?
 
Ok. I will explain to you why this document meant for. I think you have the right to ask question what can i do with the date edit.
 
DineshK
Did You noticed my question?
Don't You know an answer?
You have sent already a sample file - why needs second sample file?
Exercise ... Who needs exercise?
 
DineshK
I can make it
... happy to use it with same same data every month!
It Is Just As You Have Asked.
 

Attachments

  • All cells locked.xlsb
    40.9 KB · Views: 10
Back
Top