Combining two vba codes in the same sheet
Hello,
I have two vba codes one for time stamping the other to lock cells after data input. How would I go about combining the two in the same worksheet?
"Lock cells on data input"
"Time stamp"
Please Login or Register to view this content.
Please Login or Register to view this content.
I will greatly appreciate all the help given. Thanks
Last edited by adriel19pr; 01-11-2013 at 09:11 AM. Reason: Code was not in brackets.
Could you pls put your code between code brackets. See forum rule #1.
As for your question:
the quickest (and dirtiest) way is to change the first "end sub" into "exit sub" and you're done.
Better is to decently structure your code like this:
Of course there are more options like a select case construct.Please Login or Register to view this content.
Last edited by Tsjallie; 01-10-2013 at 04:37 PM.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Re: Combining two vba codes in the same sheet
Hello Tsjallie,
Thanks for your advise about posting the code. I tried the quickest (and dirtiest) way first and it didn't work for me. What I'm trying to do is when I input data into a cell it will lock that cell and not let me write over it. Also will need a time stamp in certain cells. I have attached the worksheet any help will be greatly appreciated.
Thanks,
adriel19pr
Your first post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Hello Zbor,
Will re-post the code again. I attached the workbook where I need the codes in. Here are the codes I have.
Please Login or Register to view this content.Can you please help me with this. Did I post the code the correct way? I truly hope so because I read and learn a lot on this forum and would not like to break any of the rules.Please Login or Register to view this content.
Thanks again.
Yea, but you could just go to first post, click edit, selecot code and click #
hello Zbor,
Thanks again will do that now.
Thanks,
Hi Adriel,
here's the workbook uploaded.
I edited the worksheet_change procedure to fit your needs (I hope).
And added some comments.
Hello Tsjallie,
I've seen that it let's me do the first time stamp then it wont run the macro after that. I would like to freeze the whole table except columns A,B,C,E,F,I,J,L,N. I would need help running the time stamp also freezing the row after entering data. It freezes the cell but then the next time stamp won't run. Am I explaining myself correctly? Please help.
Thanks
adriel19pr,
Hi Adriel,
will look into it tomorrow.
Really need some sleep now
Hi Adriel,
found the issue:
the first time the macro generates a timestamp the workbook is unprotected, but the second time it is.
When the macro wants to change the cell for the timestamp it runs into an error.
However, because there is an instruction "on error goto justenditall" it just jumps to that section skipping the whole procedure without notification.
Solution is to unprotect the workbook before the timestamp is entered and protect it again after that's done.
Please Login or Register to view this content.
Hello Tsjallie,
Thanks for all the help. Where about's do I paste your code?
Thanks
adriel19pr,
Hi Adriel,
here is the complete sub worksheet(change()
Lines to be insterted ad marked in red.
Please Login or Register to view this content.
Hello Tsjallie,
Thank you very much worked perfect.
Thanks again,
adriel19pr,
Hi Adriel,
glad I could help.
If this solved your problem pls mark your thread as solved (see thread tools).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks