Good afternoon, I wonder if it is possible to block a range of cells when they are filled with certain variables. Tanks
Good afternoon, I wonder if it is possible to block a range of cells when they are filled with certain variables. Tanks
Use the lock function of Excel and then use the worksheet protection. In this manner, those cells that have been locked cannot be changed.
http://www.excel-easy.com/examples/lock-cells.html
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Excel.JPG
I want to block the line when in the column name Distribuição the cells are filled with P or I. Do you kown how to do this?
Tanks
Take a look at using Data Validation.
For a more exact suggestion, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
STEP:1 Select whole worksheet. right click. format cells. uncheck locked.
STEP:2 Select the cells need to be blocked.right click. format cells. check locked.
STEP:3 From review tap protect your sheet by entering password.
Now your cells are blocked.
can you upload a sample copy so that i may understand your problem better.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks