hidden sheet

  • Thread starter Thread starter troc
  • Start date Start date
T

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"))
 
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)
 
Bob,

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

Thanks
 
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)




.
Click to expand...
 
Back
Top