I have created a form in Excel which I need to protect in order to lock specific cells containing formulas. However, I also need to allow staff to insert additional lines as needed. Does anyone know a way to achieve both objectives?
I have created a combo box in an Excel spreadsheet and assigned a range of values to populate it. I would like the user to have the ability to override the value options if necessary to type in an alternate value. Is this possible? If so, how is it done?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.