Making Sheet Visible
 

Hi All,

The predecessor in my job created a very useful spreadsheet with a hidden
sheet that contains all the formulae we use, we now need to change these
formulae to account for tax changes in the UK Budget, we don't have the
password (& we can't contact the person as he is now travelling abroad) to
unprotect the workbook and so we can't change them.

I wish to either copy the worksheet or make it visible in someway so i can
look at the formulae, i tried Sheets("Sheet 2").visible = true and that
didn't work.

I don't want to buy a password cracking tool and linking to the hidden sheet
only shows the values, not the formulae.

Can anyone help.
thanks