hidden sheet

[troc]

Hi,

I've got a file with several formulae in cells that all
have reference to a sheet in the file which I cannot find.
I need to change base entries in that reference sheet.
I've tried everything as instructed in help for unhiding
hidden sheets, but to no avail.
Here is a sample of the formulae in the cells.
=IF(J17="","",IF(J17=Results!$B$37,"J","L"))

 

[Bob Phillips]

Troc,

It might be very hidden, which can only be done from VBA. Try this in the
VBIDE immediate window

worksheets("Results").visible=true

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[troc]

Bob,

Thank you for fast response. However, you'll have to
excuse my ignorance. How do I do what you suggest.

Thanks

 

[troc]

I found it BOB, thank you very much

-----Original Message-----
Troc,

It might be very hidden, which can only be done from VBA. Try this in the
VBIDE immediate window

worksheets("Results").visible=true

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.