Hyperlinks

  • Thread starter Thread starter s boak
  • Start date Start date
S

s boak

Hi Folks:

I have a workbook of about 11 sheets.
Normally, 2 of the sheets are open at a time - they pull in price and other
data from 5 other sheets that are normally hidden.
If a sheet is normally hidden, is it possible to hyperlink a button that
would allow a user to open one of the sheets that's normally hidden, get
the data, and then re-hide it ??

Thanks
Steve
 
You can "pull" your price and other data from hidden sheets. No need to unhide
them just for that reason.

Sheet2 is hidden

On Sheet1 at A1 enter =Sheet2!b23

If you want to unhide the sheets, I would suggest you record a macro while
unhiding, getting data, re-hiding the sheet


Gord Dibben MS Excel MVP
 
Gord - Many thanks
However - I did not express myself correctly.
98% of the time, the pricing data pulled into Sheets 1 and 2 is complete.
The other 2%, I need price data thats on a sheet that is normally hidden -
and the format of the data is not complatible with the LOOKUPs onon #1 and
#2.

I'd like to put a button on 1 and 2 that wd allow a user to make this
normally hidden sheet visible, get the data they need, and then re-hide the
sheet on exit.

Hope this is understandable
Thanks
 
A different "take" on the problem (you said "format of the data on hidden
sheet is incompatible" but no example of "how" it's wrong)
Why not pre-format the hidden sheet range to force compatability? OR -
better alternative (since the "hidden" sheet is hidden, but clearly its
content changes, - it must take dynamic data from elsewhere). Format the
Input sheet to force compatabilty - input cells to flag "error" message?
For example, an unformatted cell will take 1O1 as input, (alpha O) but if
formatted for "number", it should flag up "input error - numbers only"
Or, have I got it wrong?
 
Back
Top