StinkeyPete wrote:
Have you looked in the VB editor?

Right click on tabview code

In the project window click on each sheet and see if you can find the
calculation.

Cell J1 on the main sheet contains the fomula =BB!G1. Sheet BB is
actually sheet 2 when viewing the code.

When viewing the code and properties for the 'workbook' it shows
asterisks adjacent to 'password', and when I try to copy the formula I
get an error message telling me the workbook is protected. How can I
ascertain this for sure?