I have built a financial model and need to provide a copy to a 3rd party for due diligence purposes.
Is there a way of saving a 'copy' that the 3rd party will only be able to 1) open the workbook, 2) view the contents and cell data such as formula, and 3) click through the tabs, 4) not be able to edit in anyway or save another copy that would be capable of editing. Basically, you can 'look but don't touch'.
The model is quite big. 65 sites workbooks (w/b) each with 8 sheet/tabs, which feeds into a region level w/b. There are 6 regions. The 6 regions then feeds into a corporate level w/b. The 65 sites and its region is held in folder. The six regions folders feed into 1 corporate w/b. All the aforementioned are contained within 1 folder which is what I propose to give to the 3rd party.
It was suggested to me that I had to protect on a sheet by sheet basis. Collectively there are over 3,150 individual tabs/sheets and so I do not see this as a practical solution.
I need to have this secured copy ready by close of play tomorrow (Wednesday 19th) so any glimmer of a swift solution would be enormously appreciated.