VBA Create Buttons On Dashboard Page

Hi, I wonder whether someone may be able to help me please.

Using a link I found here: http://www.get-digital-help.com/2012...in-a-workbook/ I've put together the following code which adds a link on a 'Dashboard' page for each given sheet within my workbook.

Please Login or Register  to view this content.

The code works absolutely fine, but I'm wanting to adapt this a little, but I'm a little unsure how to proceed.

Rather than a hyperlink being dispalyed as the link to each page, I'd like to display a custom button instead.

I've recorded the creation of the button (below) but I'm a little unsure how they can be incorporated with each other, if indeed it can be done.

Please Login or Register  to view this content.

I just wondered whether someone may be able to loo at this please and offer some guidance on how I may go about achieving this.

Many thanks and kind regards

Hi @Andy Pope, thank you very much for taking the time to reply to my post and for putting the code together, it's greatly appreciated.

I've run the code you kindly provided, but unfortunately I receive the following error: Run time error '483' Object doesn't support this property or method and debug highlights this line as the cause: .TextFrame2.TextRange.Text = DisplayText

Many thanks and kind regards

Hi, thank you very much for coming back to me with this so quickly, your solution works perfectly.

Thank you very much for your time and trouble.

All the best and kind regards