Archive of Mr Excel Message BoardArchive of Mr Excel Message Board
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!
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
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.
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!!!
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.
You are a genius and my new best friend!! Works like a charm. Thank you very much!