I want to create an excel form to collect data in a workbook list.
I need the work book list to be hidden from users. I just want users to open the workbook, fill in a form, submit it and the data to be recorded in a list.
Not sure I understand but I do something similar (I may be miles off)
I create a list of drop down boxes in data validation (then hide the rows and then protect) then my users pick from this list and it is captured on another workbook
If this sounds like what you are looking for and need more help let me know.
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.