Hello,
I have a macro that currently pastes text and charts to a Dashboard sheet from several other pre-formatted sheets. The pre-formatted sheets are copied and renamed by another macro, when the user wants to create a new sheet of one of the 5 template types we have in this tool. I would like to create easy navigation from the Dashboard sheet to the other sheets. My major problem is that they need to be able to navigate to sheets that have not yet been created or named. My solution is to include in the copy/paste macro some lines that get excel to paste a hyperlink to the template sheet on the Dashboard next to the visuals. However, I have had trouble getting the syntax down or finding relevant examples to help me through this.
I probably need to define a variable that is the last active sheet, and have that as the Address, the address must be a string. (referred to below as "Lstsheet")
I likely need to define a variable, which is the name of the last active sheet, and have that as the TextToDisplay (referred to below as "Lstname")
I need help defining the variables correctly and getting the syntax of this line correctly.
Here's where I've gotten:
At this point, the macro will have gone back and forth between last open sheet and the dashboard copy and pasting several things and will be open to the dashboard.
I have a macro that currently pastes text and charts to a Dashboard sheet from several other pre-formatted sheets. The pre-formatted sheets are copied and renamed by another macro, when the user wants to create a new sheet of one of the 5 template types we have in this tool. I would like to create easy navigation from the Dashboard sheet to the other sheets. My major problem is that they need to be able to navigate to sheets that have not yet been created or named. My solution is to include in the copy/paste macro some lines that get excel to paste a hyperlink to the template sheet on the Dashboard next to the visuals. However, I have had trouble getting the syntax down or finding relevant examples to help me through this.
I probably need to define a variable that is the last active sheet, and have that as the Address, the address must be a string. (referred to below as "Lstsheet")
I likely need to define a variable, which is the name of the last active sheet, and have that as the TextToDisplay (referred to below as "Lstname")
I need help defining the variables correctly and getting the syntax of this line correctly.
Here's where I've gotten:
At this point, the macro will have gone back and forth between last open sheet and the dashboard copy and pasting several things and will be open to the dashboard.
Code:
ActiveSheet.Hyperlinks.Add(Anchor:= "Dashboard!A15",_ Address:=Lstsheet,_ ScreenTip:= "Click here to view more or edit.",_ TextToDiplay:=Lstname)
[\code]
Thanks in advance for your time.
Best,
Anna
