LinkBack URL
About LinkBacks
Hi All,
I would like some VBA help with locking a cell based on another cells content.
If cell AT22 is greater than zero then lock cell D22
I would like this to work from cell AT22:AT221 locking cells D22:D221
Any suggestions would be welcomed ...
Hi All,
I would like some VBA help with locking a cell based on another cells content.
If cell AT22 is greater than zero then lock cell D22
I would like this to work from cell AT22:AT221 locking cells D22:D221
Any suggestions would be welcomed ...
Hi,
This should do as you require.
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Hello Jalica,
You may also want to consider this;
First Select all the Cells in the whole sheet, and with Cells Formatting change its Protection> Locked to False(That is, uncheck the "Protection Box")
In a Standard Module
In the Worksheet_Change EventPlease Login or Register to view this content.
Regards.Please Login or Register to view this content.
Last edited by Winon; 05-17-2018 at 10:28 AM. Reason: added more info
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] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks