I'm sorry for the length of the post, I am trying to provide as much info as possible.
I have a shared workbook form that various users fill in and then send to the appropriate managers for approvals. The workbook is basically a template, although just saved as a normal .xls workbook (sadly...