help with hidden excel sheet

  [DELETED] 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?

  [DELETED] 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

How to watch the World Cup for free on TV and online

Meet Superfiction, the little design studio with a load of character

Best Mac buying guide 2018

Comment résoudre les problèmes de connexion internet d’un iPhone ?