help with hidden excel sheet

  reddwarfcrew 21:01 23 Oct 2003
Locked

Hi,

I have an excel spreadsheet with the following formula:

=IF(B8="","",IF(B8=data!$B$1,"J","L"))

Now clearly it links to a sheet called 'data'.

Problem is, the 'data' sheet is not visible. There are no hidden sheets under format sheet unhide and the workbook nor sheets are protected.

So where could the 'data' sheet be?

  reddwarfcrew 21:03 23 Oct 2003

I've found that you can make a sheet 'very hidden' under its properties in VB!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Radeon Adrenalin release date, new features, compatible graphics cards

Indie publisher Canongate’s top 10 book covers of 2017

New iMac Pro release date, UK price & specs rumours

Tablettes Amazon Fire : quel modèle choisir ?