MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copying links... possible?


Posted by Lee Ann on June 22, 2001 5:23 PM

Hi there -

I am creating a report card system. The system is organized by student, and is pretty simple. I have a main 'Menu' page. On this page, I would like staff to be able to click on 'Add new student'. I would then like the 'Report Card Marks Entry' page to pop up....
To do this, I have created a macro that creates a copy of my master 'Report Card Marks Entry' page. Unfortunately, I have necessary hyperlinks on my master worksheet. When these are copied, they direct back to the master worksheet, and not the new student's current worksheet... Is there any help for me? If there is an easier way to do this, I would love to hear that too. Thank you in advance!


Posted by Lee Ann on June 23, 2001 9:52 AM

Banging my head on keyboard... what about this?

So I've been playing with this....

I figured out how to insert a template of my worksheet. This is great, but then I need to rename my newly inserted worksheet, and once again the links are rendered useless.
Is there a way to automatically update hyperlinks after a worksheet is renamed? I tried going to Edit - Links, but it is greyed out and unavailable. Thank you for your time in reading this!
Lee Ann

Posted by Dax on June 23, 2001 10:03 AM

Re: Banging my head on keyboard... what about this?

Hi,

Sorry, but I don't understand what you're asking for. You can update hyperlinks using VBA. Where should the hyperlinks on the newly created student sheet link to?

Regards,
Dax.

Posted by Lee Ann on June 23, 2001 10:47 AM

Re: Banging my head on keyboard... what about this?

The hyperlinks should link to a section on the newly created sheet.

I wish I was better at explaining these things. =)

My MASTER SHEET has hyperlinks that link to specific cells within the MASTER SHEET. When I make a copy of this 'MASTER SHEET' I want the hyperlinks to link to the same specific cells within the new copy of the 'MASTER SHEET' which I then need to rename to match the newly entered student's name. I hope that this is better.
Also, I am a novice with VBA.
Thank you!!!

Posted by Dax on June 23, 2001 11:50 AM

Re: Banging my head on keyboard... what about this?

Hi,

Right, got you now. To get around this do the following.

On your master sheet name the cells that you want the hyperlink to link to. Then change your hyperlink to jump to this named range. When you now copy the sheet it the hyperlink on the new sheet will jump to the correct place on the new sheet, not the master sheet template.

HTH,
Dax.

Posted by Lee Ann on June 23, 2001 12:34 PM

Re: Banging my head on keyboard... what about this?

You are a genius and my new best friend!! Works like a charm. Thank you very much!