Why does the EnableSelection-xlNoSelection stick thru the user interface?
I'm asking this question, because I have a specific need to lock many worksheets at one time, and not allowing any selection of cells when I'm done. I've written a VBA scription to do this. As has been posted before, the EnableSelection-xlNoSelection sticks thru the user interface, but you must insert code into the Excel that you protected for it to stick. Why does the EnableSelection-xlNoSelection stick thru the user interface? My users do not want to enable macros every time.
Does anyone know of ANY way to make this property stick, like it does by using the Protection user interface? I appreciate any help on this.
|