sheet protection

[fraz627]

I am developing an application which in which the sheet acts as a list box to select Items (using either the "Enter" key or double click, and open a userform for editing, I have it set up to high light the entire row.



Now my issue are that with out protecting the cells entries can still be made, by protecting the sheet and allowing selecting of protected cell, I get, the message saying cell is protected.

how could I prevent the message.

thanks

 

[Wanderer_geologist]

For context, i presume that you are using a userform ?
you need to have it loaded in vb model mode. Unprotect the workdheet when loading the form.
Control workflow but make sure that the worksheet is protected again while exiting the form

 

[fraz627]

Thanks
that works...