So I have one last question that you maybe able to help me with. The above table is now running great, however I have now run into a small problem. iam needing to upload my excel document into sharepoint which is fine. however Excel online doesn't support Macros, which is also not really a problem. The problem comes when said user edits the wookbook and save the excel doc. the next person to look at the excel spreadsheet or the SharePoint excel online screen gets a shown all the previous info.

How would I stop this happening so that upon closing the workbook it closes all the sheets back down apart from sheet 1 which has a bunch of instructions on.