Hello.
I'm new to VBA/macros. Is it possible to lock all cells if a specific cell is not filled in by using a password? And then unlocking the sheet once entry has been done? I'm working on a project that has 10 sections and a management code needs to be entered after completion of each section before allowing data entry user to continue.
Thanks for your help in advance!
Execute the macro on Workbook_Open as well since there won't be any change @ first.
Please Login or Register to view this content.
NINJA EDIT: I forgot to mention, that Cell "A1" has to be unlocked ofc.
Last edited by Bishonen; 10-29-2012 at 12:20 PM.
If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.
Hello celialynn,
Welcome to the Forum.
Another way without VBA Code is demonstrated in the attached WorkBook. Try it.
Also see the "Please consider" note at the bottom of this post.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello celialynn,
I assume that you liked the alternative solution to your issue.
Glad I could help in some way.
Thank you for the Rep.
I'm still having an issue. I can't protect other cells & use the password protect not to allow users to go forward. I have attached a dummy sheet hoping someone could help. Normally there will be 10 sections to each worksheet that will require approval. I thought if I hid the rows from each section until the approval was given that would work but I can't seem to find the right macor or code to do that. Any help would be appreciated.
Last edited by celialynn; 10-31-2012 at 03:40 PM.
Hello celialynn,
Please see if the attached WorkBook is what you want.
Amazing! Thank you so much! That's exactly what I wanted to do. So for each section I would you the same code but alter the range?
Hello celialynn,
Yes. You got it now......the same code but alter the range?
Happy Coding!
Thank you for your help!
For some reason, when the data is entered into the cell it opens the correct rows, but sends the cursor to the beginning of the worksheet. I'm not sure if did it correctly. Any suggestions or direction for me to go would be appreciated!
Here is what I did:
Please Login or Register to view this content.
Last edited by celialynn; 11-01-2012 at 09:26 AM.
Hello celialynn,
First of all, please do wrap your code, as stipulated in the Forum Rules, as I have done below.
Check for other Code somewhere else which might select the beginning of the Sheet. It could be in the Private Sub Worksheet_SelectionChange Event.Please Login or Register to view this content.
I checked and there isn't anything else. Is it possible after each section is unhidden to direct the cursor to an exact cell?
I found and it worked for me.
However, now I need to add my password to the protect portion of the code and i'm getting an error. Any suggestions? Thanks!Please Login or Register to view this content.
Hello celialynn,
Please show me what you have done to "Protect" within the portion of your code, so that I can help you getting rid of the error message.
This is what I started with:
I received an error message: Compile error: variable not defined.Please Login or Register to view this content.
See the changes below where I have added Option Explicit and removed the word "Password"
Please Login or Register to view this content.
Hello Again, Winon,
I have run into another problem. When I enter data it automatically takes the cursor back to the last cell referenced in the application goto reference. Is there a way to stop looping?
Please Login or Register to view this content.
Last edited by celialynn; 11-08-2012 at 05:29 PM.
Hello celialynn,
Just remove this line from wherever it appears in your Code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks