Hi guys, I'm new in Excel VBA coding, and I need to create a macro that whenever I input someting in a cell, then I pressed the form button I made, the selected cells with be locked. Please help me....
Hi guys, I'm new in Excel VBA coding, and I need to create a macro that whenever I input someting in a cell, then I pressed the form button I made, the selected cells with be locked. Please help me....
Hey!!
You can use something like this -
Between the mentioned range in the code, the code will run and unlock all the cells, then it will go through every cell and if the cell is non blank, it will lock it and protect the sheet.Please Login or Register to view this content.
Is this what you are looking for??
Thank you,
Deep
Cheers!
Deep Dave
Hi. Thank you so much it worked! Though when I merge your code to the worksheet I made, there was Error 400. I don't know what it is. Can you pls take a look at my worksheet?
Cells in column E needs to be locked everytime a date has been enter. But there seems to be an error combine you codes to mine.
Here the link of the worksheet. https://dl.dropboxusercontent.com/u/...Tool%20(3).xls
sorry I can't attach it here.
I am unable to attach the corrected file.
Kindly PM me your E-Mail id where I can E-mail you the file.
Thank You,
Deep
you can send it to me at [email protected]
Thank you so much!
Mail Sent!!
Thank You,
Deep
Hi, Deep,
as this is a forum any solution provided must be posted here.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Oooops, I am so sorry.
Below is the code -
Just minor changes to the above code!Please Login or Register to view this content.
Thank You,
Deep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks