Hello JBeaucaire
thank you about this replay
could you please modify the code with no chooses ,just never allowed modify if there is an value insertedPlease Login or Register to view this content.
Thank you
Best regards
Hello JBeaucaire
thank you about this replay
could you please modify the code with no chooses ,just never allowed modify if there is an value insertedPlease Login or Register to view this content.
Thank you
Best regards
Last edited by arlu1201; 05-13-2012 at 08:04 AM. Reason: Please put code tags in future as per forum rules.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hello JBeaucaire
Thank you
can i lock the cell which has Date & Time from previous code
if i can lock ,i Don't need to occurred any change about previous locks on the spacial cell
in another Mean prevent users to change any value after insert the Date & Time
Last edited by BASELOO; 05-13-2012 at 02:35 AM.
This would mean the sheet is currently protected, so you'd have to unlock the sheet to make changes like this:
Please Login or Register to view this content.
Last edited by JBeaucaire; 05-14-2012 at 11:06 AM.
Hello JBeaucaire
Thank you
i copied the code
and apply in excel
always i am facing this issue "compile error" in row
Range("E" & Cell.Row) .Locked = True
thank you
Take out that erroneous space in the middle of that line.
Hello JBeaucaire
i found another way
but i can't apply it on two column
could you please ckeck where the error in this code
##this code in sheet#####
Please Login or Register to view this content.
#########this code in module ###
Please Login or Register to view this content.
If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.Please Login or Register to view this content.
Hello All
working as Well
the issue solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks