Im have setup a spreadsheet that is required to be updated on a daily basis by lots of users that uses a userform to enter data onto the worksheet and the results need to be analysed, various charts created etc. I want to add a link to the userform via a website so that data can be added by anyone by accessing the website. Will this work efficiently with users and can i restrict access/hide/disable etc the worksheet controls so that only the userform appears? I have designed various web GUI using php and mysql and also asp with access etc but i want to know is the excel userform GUI a good enough solution.
Bookmarks