Dynamic Hyperlink in Autoshape based on Cell Value

[LynneDemers]

Hi,

I have created an employee schedule with 26 pay periods. Each pay period has its' own worksheet for scheduling employees.

To help navigate to the worksheets I created a home page on one of the worksheets and would like to create an AutoShape for navigating with a hyperlink based on the pay period which is selected in cell B3. When the autoshape is clicked the user would go to the correct pay period worksheet.

For example Home Page:

Cell B3 contains drop down list of the 26 pay periods which the user selects the proper pay period (ie. 8Jun14-21Jun14)
Cell E3 is a cell reference on the sheet A1
Cell B6 contains hyperlink formula =HYPERLINK("#"&"'" & B3 & "'!" & E3)
Autoshape has formula =B6

When I click on the autoshape the hyperlink does not work.

I would greatly appreciate any help setting this up as I have been attempting this for a few hours!

Thanks so much!

Lynne Demers

 

[OTOTO]

Take a peek at this discussion:

http://www.mrexcel.com/forum/excel-...yperlink-shape-visual-basic-applications.html

 

[LynneDemers]

Thank you for your reply!

I have tried adding the hyperlink to the shape, however it is static versus dynamic.

Can you kindly reference an example for adding a dynamic hyperlink to the shape?

Thanks so much!

Lynne Demers