Fount Page Example

[purceld2]

I am designing a workbook which has quite a few sheets in it so IO would like a fount page with buttons which will navigate to the sheet that concerns them. What’s the best why to do this?

Would be helpful if you have an example

Kind Regards

 

[zendog1960]

Well one way would be to create a page with hyperlinks to the different pages. This is most likely the easiest and will not require any specific VBA coding.

 

[Joe Was]

Look at Hyperlinking text to the location wanted in the Workbook.


The simple code line to goto a different sheet is:

Sheets("Sheet2").Range("A1").Select


and depending on where and how you store the code:

Sheets("Sheet2").Select
Sheets("Sheet2").Range("A1").Select

 

[purceld2]

Thank you (joe Was) very much very helpfull