In the Allow users of this sheet to list, select the elements that you want users to be able to change. Option. Allows users to. Select locked cells. Move the pointer to cells for which the Locked box is checked on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells.

By default, Excel protects a scenario from changes when you turn on protection for the worksheet so that you can’t edit or delete the scenario in any way. If you want Excel to hide the scenario as well when worksheet protection is turned on, click the Hide check box. If you don’t want to protect or hide the scenario when worksheet ... Sep 20, 2017 · Francis says:. All the codes are helpful and provided description that are easily to understand. but, my concern is can you provide a specific location where should i put the block of codes. for example, this block of codes put it in module then this one for form load, and then this one is for workbook, etc.