VBA Code to enable Design Mode, use a hyperlink to another tab, and disable Design Mode

Good afternoon all,

I'm looking for a way to insert a hyperlink in a cell that was text, and when the text is clicked, it enables Design Mode, the hyperlink works its magic, and then Design Mode is disabled, all with one click.

Unless I misunderstand your intent, you wouldn't have to specifically enter\exit design mode from VBA. It can add hyperlink directly to a cell.

I don't follow exactly what hyperlink you want to add. Could you give an example of what text is within the cell and the destination you want to hyperlink to.

Excel Hyperlinks and Hyperlink Function

VBA doesn't require a sheet to be activated to either copy or pates to it.

You don't want a hyperlink. You want to automatically run a macro when a specific cell is selected. That macro can copy from one sheet to another without having to use hyperlinks, or enter\exit edit mode, or activating any sheets.

Can you give specifics; what cell do you click on, what content do you want to copy, where do you want it pasted?

With regards to specifics:
I have a sheet called "Price Schedule" which is a compilation of products that are selected on a previous sheet, and space for certain service agreements (the templates for these are on another sheet, "Rise and Fall""; I dont want to have a macro that automatically puts stuff into a cell because there are multiple templates on the Rise and Fall sheet that the user can choose from. My ultimate goal is to allow them to change sheet, copy whichever template they want, go back to the Price Schedule sheet, and paste it into whichever area they want.

Im not looking for VBA to copy or paste anything. I just want it to Enable Design mode, use a hyperlink (or change sheet, either would work), and then disable Design Mode.