Hyperlinks

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
 
G

Gord Dibben

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
 
S

s boak

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
 
Top