Hidden Sheets within an Workbook

[HammerTime]

Hi,

I have been sent a workbook which contains a number of formulae that reference hidden worksheets (see attached JPEG). I cannot work out how to display these sheets? The workbook does not seem to be protected, I can edit and save the visible sheet. Can anyone shed some light on how to view the referenced sheets?

Thanks

[Chance2]

HammerTime,

Look under Format --> Sheet --> Unhide, you should see a dialog box to find your missing sheet.

[HammerTime]

Too easy!

Thanks Chance2

[broro183]

hi,

Should you be able to access the hidden sheets (ie is there any IP that the 3rd party is trying to protect)?

Have you tried Format - Sheets - Unhide...?

btw, a common comment relating to screenshots is - if you want help with pictures post pictures, if you want help with workbooks post... but we can let you away with it this time

hth
Rob

[broro183]

lol
It was too easy... & I was too slow!

Rob