Hi

I am using Excel 2003 and have set up a spreadsheet for a user to input details of keying errors. Basically, I have 3 tabs - Input, Data Table and MI Results. The Inputter is only allowed to see the input tab, they will enter the details, click on the macro and this moves the data into the main Table, which is hidden and password protected.
This works fine for one user. However, I now need this spreadsheet to be used by multiple users (up to 14 at any one time). When I share the workbook, the macros no longer work due to the protection on the worksheets. Is excel able to cope with this, or should I be looking for a different software solution?

Thanks in advance for your help.