What can I do in Excel this: in a cell to choose from a list value, when I chose the value in the list to the cell block.
What can I do in Excel this: in a cell to choose from a list value, when I chose the value in the list to the cell block.
In the attached example, we start with all cells unlocked and the worksheet unprotected. Once the user has entered a value in cell C4, an Event macro locks that cell and protects the worksheet. Macros must be enabled for this to work.
Gary's Student
Thank you. but if you want the list to be in a certain cell, how do? .. if I copy the list in cell C4 in another cell does not work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks