ExcelBanter - UserInterfaceOnly

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - UserInterfaceOnly (https://www.excelbanter.com/excel-discussion-misc-queries/26477-userinterfaceonly.html)

D.Parker

UserInterfaceOnly

Hello. Is there a way to separate certain ranges from the protection of
UserInterfaceOnly, such that the user can input information into certain
cells?

Kind regards,

D.Parker

Dave Peterson

Unlock the cells and then both the user and the code can change these cells.

D.Parker wrote:

Hello. Is there a way to separate certain ranges from the protection of
UserInterfaceOnly, such that the user can input information into certain
cells?

Kind regards,

D.Parker

--

Dave Peterson

All times are GMT +1. The time now is 01:12 PM.