I need to create 2 hyperlinks for an intranet web page each of which will open to a different worksheet in the same Excel workbook. I have created labels for each of the A1 cells. So, worksheet 1’s A1 is labeled “StepItUp” and worksheet 2’s label for A1 is “LightenUp”. When I use this it goes to worksheet 2, and when I use to also goes to worksheet 2. I’ve also tried, where #Step_It_up is the worksheet name and !stepitup is the label for cell A1 on that worksheet. It still goes to worksheet 2. I can’t believe there’s no way to create two hyperlinks on a webpage each of which goes to a different worksheet in the same workbook. Do you all have the solution?
