LinkBack URL
About LinkBacks
Hello Bos ? I want lock (disabled) one or some cells with excel macro, so user can not entry or change the data.
Examp. : Lock only A7, D8, E10, etc.
But other cell is not locked (entry data is enabled).
Thank's
Hello Bos ? I want lock (disabled) one or some cells with excel macro, so user can not entry or change the data.
Examp. : Lock only A7, D8, E10, etc.
But other cell is not locked (entry data is enabled).
Thank's
You don't need a macro.
By default all the cells on an Excel sheet are locked.
To unlock the ones you want unlocked, select them, then 'Format', 'Cell', 'Protection', and remove the mark from 'Locked'.
You then need to Protect the worksheet.
If you find the response helpful please click the scales in the blue bar above and rate it
If you don't like the response, don't bother with the scales, they are not for you
Re: Lock only one or some cells
Thank's Mr. Phil..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks